var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: 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:
This does not work and I get the following:
dtsrun /F package1
dtsrun /F package2
C:\WINDOWS>dtsrun /F package1
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?
What happens when you fully path out the package files?
I love cursor,though I never use it.Cos' I dont want to misuse it.
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