I have two Execute SQL tasks. The one for populating the variable. I have the variable in the ResultSet and the settign is Single Row. THe second Execute SQL task is for the update. I put the User::variable name in the variable name field, Input in the direction field, VARCHAR in the Data Type field, and the variable name in the Parameter Name field. I have the ResultSet set to none, but it fails no matter what ResultSet I put in.

I am getting the followiing error: [Execute SQL Task] Error: Executing the query "update Table

set DataField =..." failed with the following error: "Parameter name is unrecognized.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Where am I going wrong?

WHEELS