Post reply

Parameters for OLE DB Connection Manager

  • April 29, 2011 at 3:35 am

    #148967

    [font="Tahoma"]

    Hello Friends,

    I have configured OLE DB Connection Manager and trying to use an Execute SQL Task control flow with parameter. I am trying to drop the table using the execute sql task. so this is the sql statement that i am using.

    Drop Table ?

    However, i am getting an error stating Incorrect syntax near '@P1'. The parameters work fine when i use ADO.Net connection Manager.

    However, i am unable to find the reason why its not working with OLEDB conn Manager.

    Please help me on this.

    [/font]

  • April 29, 2011 at 3:52 am

    #1317712

    Hi,

    Create a variable , then pass the value (either hard code or get it dynamic ) then do the mapping of that parameter in Execute SQL task.

    While declaring the variable no need to give @P1. Give some name say tablename , then give default value and in the Execute SQL task do the parameter mapping.

    Thanks & Regards,
    MC

  • April 29, 2011 at 3:58 am

    #1317714

    [font="Tahoma"]

    Hello Thanks for the response. I have already declared the variable and mapped the same. I am attaching the package for your response. Kindly check it and let me know if something is wrong.

    [/font]

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

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