Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78

    Question 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:

    Code:
    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.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    What happens when you fully path out the package files?

  3. #3
    Join Date
    Jun 2003
    Posts
    269
    check this link ,it may help u.
    http://www.sqlteam.com/item.asp?ItemID=16512
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  4. #4
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78
    By fully path I guess you mean C:\folder\xyz etc...?

    If so then I just tried that and still the same error.

  5. #5
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78
    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

    NeilA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •