Post reply

help with params in execute sql task

  • November 20, 2009 at 8:39 am

    #385824

    Hi,

    I am using a Bulk Insert statement in execute sql task (SSIS 2005).

    Bulk Insert #Legacy

    From ?

    In the parameter mapping page, i configured the paramater. But this gives throws an error

    [Execute SQL Task] Error: Executing the query "Bulk Insert #Legacy From ?" failed with the following error: "Incorrect syntax near '@P1'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Can't we use parameters for Bulk Insert or am i missing something.

    Thanks,

  • November 20, 2009 at 9:12 am

    #1082305

    Looking at BULK INSERT in BOL (Books Online, the SQL Server Help System), it appears that to accomplish what you are trying to do you will need to use dynamic sql.

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

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