We help IT Professionals succeed at work.
Get Started

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

4,415 Views
Last Modified: 2016-02-10
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
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE