run sql sp and pass value

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  January 5, 2009 at 7:36 am

  #127774

  Hi how can i call the procedure in the SSIS task. I could use SQL task but how can i set the parameter with the package variable.

  such as ,

  i have variable define. name and want to execute the sp with

  storeprocedure name so it can take the value of name variable!!

  thanks

  Pat

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  January 5, 2009 at 7:46 am

  #921126

  You need to specify "Variable" as SQLSourceType property of the Execute SQL task...

  --Ramesh
  

  ---