Results 1 to 4 of 4

Thread: DTS execution

  1. #1
    Join Date
    Mar 2007
    Posts
    6

    Unanswered: DTS execution

    I'm having trouble with dts. I used the dtswizard to create a dts package, yet when I use dtsrun with the package name, I get a message saying that the package cannot be found. I've even copied the .dtsx file into the same folder as dtsrun and still gotten the same message. Can someone shed some light on what I might be messing up. Btw, I'd love to run the dtsrunui, but apparently that file wasn't part of my distribution.

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    where have u saved your package? inside sql server or as a disk file. it appears that it was saved as disk file. so u should mention the file path with /F switch during dtsrun call. to have it available under dtsrunui u should first select "Structured Storage File" and point to the location of the saved file if not saved inside sql server.

  3. #3
    Join Date
    Mar 2007
    Posts
    6
    I've tried saving the file or even copying the .dtsx file right to the root just to make the path simple, but then the process tells me it is not a dts package. How can the dtswizard create a file that isn't truly a dts package? In a related note, how can I "get my hands on" the dtsrunui executable. It's not on my system, nor is the dtsexecui. Either of these would make this process simpler for me I'm sure

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Greetings, Mark! For those of you following this thread, I'm coming into it with a fair bit of background from outside this thread... I didn't somehow magically divine the background from just what's posted.

    I'm assuming that this is the SSIS package you built using the Transact-SQL that I provided, and that you are running this on the SQL 2005 Express machine... If any of those assumptions are bad, the rest of this message is worthless.

    If I told you to use DTSRUN, that was my mistake... I should have specified DTSEXEC. See the web page on dtsrun to dtexec Command Option Mapping for more details on the conversion from DTSRUN to DTSEXEC.

    Anywho, its good to see you here! Hopefully you'll get quicker answers here than waiting for me, but then again I do make "housecalls" for old friends when I'm in the neighborhood!

    -PatP

Posting Permissions

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