Hi, I am trying to use an integer as input parameter for my task I get suck on the parameter data type.The input parameter is define as @Control_ID variable as Int32 in SSIS. When I got into the parameter mapping of Execute SQL Task, I don't find the Int32 data type. I used to try Short, Numeric, Decimal and so on, but all of those data type didn't work. and it returns the following error message:SSIS package "DCLoading.dtsx" starting.Error: 0xC002F210 at Update Control_ID, Execute SQL Task: Executing the query "use DCAStaging update DCA_HFStaging set [dbo].[Control_ID] = P0 where [Control_ID] is null" failed with the following error: "The multi-part identifier "dbo.Control_ID" could not be bound.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.Task failed: Update Control_IDWarning: 0x80019002 at DCLoading: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.SSIS package "DCLoading.dtsx" finished: Failure.Any help?

this link might help: http://www.sqlis.com/default.aspx?58

Thanks for the response. The link you posted is helpful, but does not include the example that I need. I want to set anInt32 variable asintput parameter, but I don't find any integer type in the parameter mapping. And, if I set the SSIS variable as string type, in the parameter mapping, I set the input parameter as varchar, it will return error said the parameter length can't be defined.

This is way late - but for anyone else running into this, use LONG. Talk to me now on

It's never too late! Just had this issue and LONG works for me. Many thanks.