Link to home
Start Free TrialLog in
Avatar of Sal Overmars
Sal OvermarsFlag for United States of America

asked on

INSERT INTO inside SQL Task Editor error

I have an Execute SQL task that has this query:

TRUNCATE TABLE [table]
INSERT INTO [table]
EXEC usp_populate ?, ? , ?

Open in new window

and I have the  third ? is the only one giving me this error.
insert int..." 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.

I tried to change the variable data type to int, float, string but that didn't help.

here's a screenshot of my Parameter Mapping setup. Is there anything that I'm missing?

User generated image


ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada 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