Amanda Walshaw
asked on
Executing SQL Task on SSIS Package SQL 2008
I am trying to execute the following stored procedure and I keep getting the following error
SSIS package "procube8.dtsx" starting.
Error: 0xC00291E2 at exec procube prepare starschema, Execute SQL Task: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset".
Task failed: exec procube prepare starschema
SSIS package "procube8.dtsx" finished: Success.
The stored procedure runs okay in query analyser
it is
EXEC dbo.procube_prepare_starsc hema
I have attached the setup of sql task
executing-task--error-in-SSIS-pa.docx
SSIS package "procube8.dtsx" starting.
Error: 0xC00291E2 at exec procube prepare starschema, Execute SQL Task: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset".
Task failed: exec procube prepare starschema
SSIS package "procube8.dtsx" finished: Success.
The stored procedure runs okay in query analyser
it is
EXEC dbo.procube_prepare_starsc
I have attached the setup of sql task
executing-task--error-in-SSIS-pa.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.