DTSRunUI tool and which package version is executed in job

Question

DTSRunUI tool and which package version is executed in job

bellis

SSCarpal Tunnel

Points: 4667
More actions
April 20, 2004 at 8:07 am

#161218

I have a couple of questions concerning the DTSRunUI tool:

1) When using the DTSRunUI tool to generate the DTSRun command, if you simply select the package name (and you do not specify a version), the following command is generated…

DTSRun /S "STLSRV0001" /N "MAINT_Refresh_Code_Desc" /G "{61223311-92B1-11D6-BC5B-00080232FCF4}" /W "0" /E

After pasting this information into a job step, does this execute the latest version of the DTS package even if you make changes to the DTS package after creating the job? Simply put, will this command always execute the latest version?

2) If you actually specify the version to run, the following command is generated by the tool…

DTSRun /S "STLSRV0001" /N "MAINT_Refresh_Code_Desc" /V "{C670911A-D1E1-406B-A571-5526035E3F88}" /W "0" /E

This command will always run the specific version that you chose, regardless of later versions that are created, correct?

3) Lastly, if you use the command generated by #2 above in a scheduled job, and then at a later date, this specific version is deleted, the job will fail, correct?

Thanks!!!
Brian

P.S.
From BOL...
/G package_guid_string
Is the package ID assigned to the DTS package when it was created. The package ID is a GUID.
/V package_version_guid_string
Is the version ID assigned to the DTS package when it was first saved or executed. A new version ID is assigned to the DTS package each time it is modified. The version ID is a GUID.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

1. Yes, the latest version will always be executed. The package GUID remains the same regardless of how many versions are saved.

2. Correct.

3. Right again. A new version GUID is generated each time a version is saved, so if a version is deleted, the DTSRUN command will generate an error.

There's an article on sqldts.com: http://www.sqldts.com/default.aspx?301

Greg

bellis SSCarpal Tunnel Points: 4667 More actions · Answer 2

Greg,

Thanks for the reply. SQLDTS.com is often a resource that I use and recommend, but my first source is always this forum. I always get a quick response and meaningful information. Concerning SQLDTS.com and the article, I have pulled in the following information to post here...

The command [generated by DTSRunUI] will contain either the version GUID or package GUID, depending on if you selected a specific version or the package only. Since the command line also contains the name, and only one of the three is required, and since most people think in names not GUIDs it is usual to remove the GUID and just leave the name. This ensures that if you change the package or replace it, in a way such that the specified GUID changes, you do not have to update the command line string.

For example, the example command line is:

DTSRun /S "(local)" /N "MyPackage"   /V "{92A57960-D9E1-40F4-9919-5773E9E35F12}"   /A "MyStringVar":"8"="String Value"   /A "MyIntegerVar":"3"="1" /W "0" /E

For flexibility this can be shortened to:

DTSRun /S "(local)" /N "MyPackage"   /A "MyStringVar":"8"="String Value"   /A "MyIntegerVar":"3"="1" /W "0" /E