Tips and Tricks for:  SQL Server

The Problem:   How to get the GUID for the DTSRUN command line?

The way to run a DTS package from a stored procedure or a SQL Agent job is to use DTSRUN.  Building the command line for DTSRUN requires that you find the GUID for it and correctly copy it to the command line.

Solution: Use the DTSRUNUI utility to make the command line for you.

DTSRUNUI can be run like any other command line utility from  DOS prompt or from Windows' Start/Run menu.   Just select your server and a package.  Then press the Advanced button to go to the Advanced form and select any options you plan on using. Finally, press the GENERATE button and the DTSRUN with the correct GUID and any options that you selected is created. Copy the DTSRUN command to the left of the button.  It's highlighted in green in this picture: