Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

setting a DTS package to run as a job

Status
Not open for further replies.

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..
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top