February 26, 2009 at 8:39 am
I'm trying to insert a row into a table using variables as input but have error...:crying:
On Execute SQL Task:
INSERT table_name (column)
VALUES (?)
Parameter Mapping:
Variable Name - User::Type
Direction - Input
Data Type - Varchar
Parameter - NewParameterName
Parameter Size - 0
Error:
[Execute SQL Task] Error: Executing the query "INSERT table_name (column) VALUES (?) " failed with the following error: "Parameter name is unrecognized.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
If I do this, it works...
On Execute SQL Task:
INSERT table_name (column)
VALUES ('test')
Can anyone help me on this?
TIA
February 26, 2009 at 1:19 pm
Change 'NewParameterName' in the Parameter field to 0. This assumes you are using an OLE DB connection, which uses numbers to identify parameters, starting with 0.
February 26, 2009 at 1:28 pm
That's what I missed...It's working now Tahnks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy