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
Microsoft SQL ServerMicrosoft SQL Server 2008SSISSQL

Avatar of undefined
Last Comment
ProjectChampion

8/22/2022 - Mon
ProjectChampion

>> "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 ?,?,?,?"
Amour22015

ASKER
Ok,

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

EXEC Purge_By_FileId ?,?,?,?

Thanks
ProjectChampion

Can you please post the stored proc signature?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Amour22015

ASKER
I have attached:

Stored Procedure
SSIS Package

Thanks
Purge-by-fileid.docx
SnapshotPassingVariables.docx
ASKER CERTIFIED SOLUTION
ProjectChampion

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Amour22015

ASKER
Looks good
Amour22015

ASKER
Great thanks
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ProjectChampion

You're welcome!  : )