April 29, 2011 at 3:35 am
[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
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
[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