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
Showing posts with label dtsrun. Show all posts
Showing posts with label dtsrun. Show all posts
Friday, March 23, 2012
Subscribe to:
Posts (Atom)