April 10, 2011 at 6:45 pm
I can get everything to work in the control flow except for the last sql task to execute a stored procedure
error I am getting is
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.
If I change to none
SSIS package "procube8.dtsx" starting.
Error: 0xC002F210 at exec procube prepare starschema, Execute SQL Task: Executing the query "EXEC dbo.procube_prepare_starschema" failed with the following error: "Login failed for user 'procube8'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: exec procube prepare starschema
SSIS package "procube8.dtsx" finished: Success.
permissions are correct etc, please find attached snapshots on how I have setup this task.
April 10, 2011 at 9:48 pm
Could be due to the result set property not being set correctly or also due to the error caused by the statement in the execute SQL task. The task gives u a generic message on failure. See if this blog helps. Look for execute SQL task failure blog post.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply