DTS Local Package from Stored Procedure

• ralcure

  SSC Enthusiast

  Points: 168

  More actions

  May 16, 2002 at 12:30 pm

  #78755

  How can I execute a local package from within a stored procedure ?

  It believe DTSRun is not the case...

  Thanks

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  May 16, 2002 at 1:11 pm

  #429305

  The easiest way is to use DTSRun in a job, then have the stored procedure start the job.

  Andy

  Andy
  Connect with me on LinkedIn