Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: Run saved DTS package in 2005

    I have saved a DTS Package, in sql serv 2005. How do i run it ? I cant fiqure it out

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Liar.

    You do not have a saved DTS package in 2005. 2005 does not support DTS packages.

    Shame on you for trying to decieve people!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Sep 2004
    Location
    CA
    Posts
    41
    You need to make sure the DTS runtime has been installed.

    http://msdn2.microsoft.com/en-us/lib...6(SQL.90).aspx

  4. #4
    Join Date
    Oct 2003
    Posts
    311
    Blindman -- must be

    When talking about dts i was referring to the equivalent, guess that was to much logic for you to handle

  5. #5
    Join Date
    Sep 2004
    Location
    CA
    Posts
    41
    Quote Originally Posted by mikezcg
    I have saved a DTS Package, in sql serv 2005. How do i run it ? I cant fiqure it out
    Manually or scheduled?

    In the BI Dev Studio you just right click to run. If you run as a job, then just choose the package when you set up the job step(s).

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by mikezcg
    Blindman -- must be

    When talking about dts i was referring to the equivalent, guess that was to much logic for you to handle
    Blind leading the blind. You need to be clear, because you can access SQL 2000 database from the 2005 Management studio and even see a list of DTS packages, but you can't edit or run them.

    Thus, the need for clarity...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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