I keep getting this error:
SSIS package "ClaimPurge.dtsx" starting.
Error: 0xC002F210 at Purge Claims, Execute SQL Task: Executing the query "EXEC Purge_By_FileId ,?,?,?,?" failed with the following error: "An error occurred while extracting the result into a variable of type (DBTYPE_I4)". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Purge Claims
This is a:
Result Set: Full result set
Connection: OLE DB
TblVal datatype Object
there is a SQLStatement like:
so i have a
tblVal with a datatype = object
so that I can pass to a "Foreach Loop Container"
The datatype in the table were I am getting the field is:
The datatype to the SP to be finally passed to is:
So I am passing a Object (datatype) to a In32(DT_I4 - int) datatype
Please help and thanks