Error:
SQL SPLoadxxx:Error: Executing the query "EXEC SPLoadxxx ?" failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
When I executed the Stored procedure it executed perfectly.
So seems SSIS was not able to execute it properly and I found out that
"The Execute SQL Task" in SSIS "Parameter Mapping" had an extra parameter which was not been used by the Stored procedure.
SQL SPLoadxxx:Error: Executing the query "EXEC SPLoadxxx ?" failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
When I executed the Stored procedure it executed perfectly.
So seems SSIS was not able to execute it properly and I found out that
"The Execute SQL Task" in SSIS "Parameter Mapping" had an extra parameter which was not been used by the Stored procedure.
No comments:
Post a Comment