Friday, March 23, 2012

Need dtsrun help

I am trying to run two dts jobs using a batch file obviously using dtsrun but im having trouble. I've never attempted this before and it looked easy but not as easy as I thought.

I have two dts jobs, call them package1 and package2. I also saved these as .dts files. I made a .bat file and put it in the same location as the .dts files.

My batch file looks like this:

dtsrun /F package1
dtsrun /F package2
pause

This does not work and I get the following:

C:\WINDOWS>dtsrun /F package1
DTSRun: Loading...

Error: -2147287038 (80030002); Provider Error: 0 (0)
Error string: The system cannot find the file specified.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 704

Can anyone help and tell me what I am doing wrong?

Thanks

Neil.What happens when you fully path out the package files?|||check this link ,it may help u.
http://www.sqlteam.com/item.asp?ItemID=16512|||By fully path I guess you mean C:\folder\xyz etc...?

If so then I just tried that and still the same error.|||Oh dear, I'm definately having a slow day today...

I had a thought about where I was running the batch file from. I was running it from my PC even though it is located on the server. I then remote connected to the server and ran it there, IT WORKS!

Sorry for trouble but thanks for the link

NeilAsql

No comments:

Post a Comment