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.

Seeing?

[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) 

References

http://technet.microsoft.com/en-us/library/ms140355.aspx