Edit Question - KnowledgeHub

Title Body

I have a SQL Task that needs to run a simple update to update a single row. I have set the SQLStatement to: update agency set AgencyLastBatchSeqNo = ? where agencyID = ? On the Parameter Mapping page I gave set Parameter 0 and Parameter 1 to variables that I know contain the right values. I have also set the Parameter Name values correctly. In the database, the column AgencyLastBatchSeqNo is an int, AgencyID is a big int. Does anyone have a reference to find what the data types map to in SSIS? I have guessed at SHORT for the int and LONG for the big int. When I run the task I get the following error: [Execute SQL Task] Error: Executing the query "update agency set AgencyLastBatchSeqNo = ? where AgencyID = ?" 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. Could anyone please suggest what may be wrong? Thanks Rob.

Tags (comma-separated) Cancel