Sal Overmars
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 ?, ? , ?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.