DTSRUN

[pbd1963]

I've created a DTS package that I saved as a file and execute using the DTSRUN utility. If I try to run the package with the following parameters I get the following errors:

>dtsrun /F"business units.dts"


DTSRun: Loading...



Error: -2147220438 (8004042A); Provider Error: 0 (0)

Error string: The specified Storage File contains multiple Packages; Loading requires a Name or Guid.

Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts.hlp

Help context: 704


I can then add the /G parameter and the DTS package will run:

>dtsrun /F"business units.dts" /G995C6DD4-0279-11D5-AA87-000255705759

DTSRun: Loading...

DTSRun: Executing...

DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1

DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1

DTSRun OnStart: DTSStep_DTSDataPumpTask_1

DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 213 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 213

DTSRun OnFinish: DTSStep_DTSDataPumpTask_1

DTSRun: Package execution complete.


There are different versions of the package when I view the Properties for the package. I would like to be able to run the DTSRUN command without the /G parameter. Won't the Package GUID change as the package is modified? I am running DTSRUN from with a .BAT file and capturing all output to a .LOG file.

Anyone have any ideas?

Paul Dunn

 

[jballum]

Paul,

It seems when you save the DTS package to a file that already exists it does not overwrite the package it actually adds it to the existing package(s) in the file.

To solve your problem before saving the package from Enterprise Manager using the Data Transformation Services erase the existing file (or rename for history) and then save the package. You should then be able to run the package with only /F"filename.dts" parameter.

JB