SSIS Data Conversion Errors

Question

We are trying to Execute a SQL Server Stored Procedure with our Table Data Types clearly defined as INT. We are then trying to store the Result Set into Variables. We thought the SSIS Variable should be defined as Int32 according to web site...

https://milambda.blogspot.com/2014/02/sql-server-integration-services-data.html

But we are getting the error message...

Error: 0xC002F309 at Execute SQL Task - Data Lookup, Execute SQL Task: An error occurred while assigning a value to variable "PackageQuantity": "Input string was not in a correct format.".

Do we have to actually CONVERT in our SQL Server Stored Procedure?

Can we change the Data Type on our SSIS Variable to Object?

This is VERY FRUSTRATING.

I hope I get a solid response to my post please.

Thanks for your review and am hopeful for a reply.

Answer 1

Table Data Types clearly defined as INT
Input string was not in a correct format.

The error message clearly mention the input string = source data, not the target table. You have to check the source data if it contains string value, which can't be converted to an integer value.