DTS Package Execution

• sstecher

  Ten Centuries

  Points: 1057

  More actions

  December 17, 2004 at 11:50 am

  #84393

  I apologize for my ignorance.

  But how do you execute a DTS Package within a stored proc?

  Thanks, Shane

• Jimmy Jen

  SSCrazy

  Points: 2915

  More actions

  December 17, 2004 at 12:38 pm

  #534361

  exec xp_cmdshell 'dtsrun /S servername /E /N"dtsname"'

• sstecher

  Ten Centuries

  Points: 1057

  More actions

  December 17, 2004 at 12:41 pm

  #534362

  I never even thought about using cmdshell.

  Thanks Bud!!