call SP from SSIS package and pass the variable value

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  January 5, 2009 at 8:12 pm

  #133473

  Hi all,

  how can i call SP in SSIS package. I tried with Execute SQL Task but not able to do it. i need to pass package variable as the parameter to sp.

  such as exec sp packagevariable

  How can i do it!! please help

  thanks

  Pat

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  January 6, 2009 at 12:53 am

  #921599

  You can do it with the help of Execute SQL Task. Here is what you need to do:

  - Double click on your SQL task.

  - On the general tab set QueryIsStoredProcedure to TRUE.

  - For mapping the parameters refer following link from msnd http://msdn.microsoft.com/en-us/library/ms187685.aspx

  - Vikas Bindra

  Sr. Software Engineer - BI

  -Vikas Bindra