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!

dtsrun error

Status
Not open for further replies.

anastasiafed

Technical User
Jun 11, 2003
4
US
Hi
I have a dts package that executes another package as one of it's tasks.

Both packages are stored as structured storage files.

I am trying to execute the parent package from command prompt using the dtsrun utility. The package executes successfully until it gets to the step that should start the second package. At this point I get the following error:

Error: -21477287037 (80030003); Provider Error: 0 (0)
Error string: The system cannot find the path specified.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
etc.

The path to the child package is assigned automatically during the run time and is stored as a global variable. When I run the master package from the Enterprise Manager it executes successfully all the way through.

Any help would be greatly appreciated.

Anastasia.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top