Aug 18, 2004 #1 rsx Programmer Dec 12, 2002 28 CA hello, can someone show me the code for setting up a step within a job to execute a dts package? thanks very much..
hello, can someone show me the code for setting up a step within a job to execute a dts package? thanks very much..
Aug 18, 2004 #2 RobertT687 Programmer Apr 2, 2001 425 US Easy. On your job step, have it executing an operating system command. Command is: DTSRun /S /E /N "your DTS package name here" /S means the local server /E means use a trusted connection /N preceeds the name of your package. Upvote 0 Downvote
Easy. On your job step, have it executing an operating system command. Command is: DTSRun /S /E /N "your DTS package name here" /S means the local server /E means use a trusted connection /N preceeds the name of your package.