I have created a SSIS package which runs every hour from my Machine. First part of my Package runs a Execute SQL Task and result set (single row, single column) is a comma separated list of Unique Record Ids which have been updated in last hour. (i.e. FJ1,FJ2,FJ3) I capture this result in a variable and when I User script tasks to display the value of this property, it appears as it should be.
I pass this Variable to Execute SQL Task on different ODBC Server using a Stored Procedure
My SQL Statement is as Following
And then I have assigned my Variable (as SQL_Longvarchar) to Parameter 1 in Parameter mapping Section. (ParameterSize is -1) but it doesn't delete the records from the table. (I ran the SP manually in Workbench and it works as expected) Then I had an idea and as part of my SP I started making entries in a Temp table just to see whats coming up as variable. Insert in the table shows only first character from the variable and which is why it's not deleting any records.
Can someone please point me to the right direction as I can not find why my variable is being truncated.