A blog about SQL Server, SSIS, C# and whatever else I happen to be dealing with in my professional life.

Find ramblings

Monday, February 8, 2010

SSIS Execute SQL task with full results, OLE DB connection manager

This post is a brief troubleshooting post on the error messages generated in SSIS Execute SQL task with full results using an OLE DB connection manager.
[Execute SQL Task] Error: The result binding name must be set to zero for full result set and XML results.

It means you need to update the "Result Name" from -1 to 0 in the "Result Set" tab on your Execute SQL Task Editor.

Fix that and then getting?
[Execute SQL Task] Error: Executing the query "..." failed with the following error: "Parameter name is unrecognized.". 

On the Parameter Mapping tab, change the default Parameter Name from "NewParameterName" to 0 (or whatever the appropriate ordinal is) 


No comments: