Link to home
Start Free TrialLog in
Avatar of Amour22015
Amour22015

asked on

SSIS 2008 - MAPPING A OBJECT (RESULTSET) TO VARIABLE INT32

Hi experts,

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:
Select
Fileids
tblnms
from table

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:
File_id int,

The datatype to the SP to be finally passed to is:
file_id int,

So I am passing a Object (datatype) to a In32(DT_I4 - int) datatype

Please help and thanks
Avatar of ProjectChampion
ProjectChampion
Flag of United Kingdom of Great Britain and Northern Ireland image

>> "EXEC Purge_By_FileId ,?,?,?,?"
I can see a redundant comma after the name of the proc, is this really in the error message or just a typo?
T correct call to the proc should be:
"EXEC Purge_By_FileId ?,?,?,?"
Avatar of Amour22015
Amour22015

ASKER

Ok,

I took out the extra "," but still got the same error.

EXEC Purge_By_FileId ?,?,?,?

Thanks
Can you please post the stored proc signature?
I have attached:

Stored Procedure
SSIS Package

Thanks
Purge-by-fileid.docx
SnapshotPassingVariables.docx
ASKER CERTIFIED SOLUTION
Avatar of ProjectChampion
ProjectChampion
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Looks good
Great thanks
You're welcome!  : )