Passing DTS Parameters

• brodeyo

  Grasshopper

  Points: 20

  More actions

  January 29, 2004 at 1:03 pm

  #59641

  Is there a way to pass a DTS Package a Parameter when calling it from TSQL? Something like this, but adding a parameter on the end...? EXEC master..xp_cmdshell 'DTSRUN /S ntohtxtsql02 /E /N New_Collections_TESTING'

• philcart

  SSC-Forever

  Points: 47797

  More actions

  January 29, 2004 at 5:05 pm

  #492272

  If you're runing SQL 2000, you can use the /A parameter. Check out the Books Online topic for the syntax.

   

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

• brodeyo

  Grasshopper

  Points: 20

  More actions

  January 30, 2004 at 6:44 am

  #492310

  Great! I can't believe I didn't even see that in Books Online. Thank You!