Running a DTS package

• Roust_m

  SSCoach

  Points: 17410

  More actions

  September 2, 2003 at 3:27 am

  #106453

  Hi!

  The only reason for using xp_cmdshell by ordinary users in my database is starting a DTS package from a stored procedure. I really would like to avoid using xp_cmdshell.

  Is there other way to start DTS package from an SP?

  Thanks.

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  September 2, 2003 at 2:08 pm

  #472252

  You could create a sql scheduled task to run the job, then allow the users to run sp_start_job to start the job.

  Steven

• philcart

  SSC-Forever

  Points: 47795

  More actions

  September 3, 2003 at 1:26 am

  #472309

  Just to add steven_white40's reply, if you setup a scheduled task, make sure you disable, or remove, the schedule.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface