parameterised SP in DTS? y not!

• rezaislam

  SSC Rookie

  Points: 30

  More actions

  April 15, 2005 at 1:13 pm

  #164086

  I have been searching for threads in various forums best part of 7 months. I have finally plucked up the courage to write my own thread here!!!

  Can anyone tell me if there is a way around writing a DTS which runs a parametrised stored procedure? I've tried it the logical way by selecting to execute task and the typing 'exec sp_....' and this obviosuly does not work. 

  I have been advised by someone that i may need to wrap the SP within a UDF. Im no good with UDF's, any bright sparks out there able to point me in the right direction?? If you're in London I'll get you a pint!!!

  Many thanks in advance! 

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  April 15, 2005 at 1:31 pm

  #553002

  >>I've tried it the logical way by selecting to execute task and the typing 'exec sp_....' and this obviosuly does not work. 

  It's pretty obvious that it does work, hence the large button at the bottom of the ExecSQL task UI labelled "Parameters".

  What are you trying to pass into the sproc as parameters ? Global DTS variables ?