Post reply

SQL Task error

  • February 26, 2009 at 8:39 am

    #384025

    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

    #950810

    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

    #950820

    That's what I missed...It's working now Tahnks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply