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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Jobs - Exec DTS packages

Status
Not open for further replies.

dakone

Programmer
Jun 23, 2003
28
CA
When building a job in the server agent, what is the proper syntax to exec a DTS package?
 
Rever to BOL for more information, but here is a simple example:

DTSRun /SServerName /E /N "Package Name"

So to run the "Archive" package on the "Alpha" server...

DTSRun /SAlpha /E /N "Archive"

Jim
 
Thanks for the help,

Although I had to use the Package GUID inorder for it to run.

DTSRUN / "~GUID"

Something new everyday!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top