execute a SP in the execute SQL Task

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

execute a SP in the execute SQL Task

Author

Topic

jung1975
Aged Yak Warrior

503 Posts

Posted - 2007-01-25 : 16:32:04

I am trying to execute a SP in the execute SQL task in SSIS 2005..

but I keep getting an error:

SSIS package "Package.dtsx" starting.
Error: 0xC002F210 at Load_Gs_Modifier_1, Execute SQL Task: Executing the query "exec Load_GS_Modifier_1 ?, ?" failed with the following error: "Could not find stored procedure 'exec Load_GS_Modifier_1 ?, ?'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Load_Gs_Modifier_1
SSIS package "Package.dtsx" finis

I have set up two user parameters: startdate and enddate.. I am not sure what I am doing wrong????

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-25 : 16:54:02

Try and prefix the SP with database and owner.

Peter Larsson
Helsingborg, Sweden

jung1975
Aged Yak Warrior

503 Posts

Posted - 2007-01-25 : 17:37:53

Thanks.. i tried it,but still getting the same error..
I think it;s something to do with parameters.. just can not figure it out???

nr
SQLTeam MVY

12543 Posts

Posted - 2007-01-25 : 19:06:19

Have you tried it without parameters? Does it find the SP then.
I always construct the sp call in an expression - doesn't have these problems.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources