Results 1 to 11 of 11
  1. #1
    Join Date
    Oct 2008
    Posts
    22

    Unanswered: Where do i find the DTS ?

    We just migrated from MS SQL 2000 to 2005 express but cant find the dts package, so installed 2008 express, whcih looks the same as 2005

    Where do i find the DTS ?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    DTS is deprecated and is not included or supported in SQL Server 2005.
    Instead, use SSIS (SQL Server Integration Services) packages, which can be created SQL Server Business Intelligence Development Studio. The Business Intelligence Development Studio should be installed as part of your SQL Server 2005 install.
    If it's not practically useful, then it's practically useless.

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

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    2005 does not support the creation of new DTS packages but does allow you to port your old ones across (Management > Legacy > Data Transformation Services).
    George
    Home | Blog

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Well, it will allow you to execute the packages, but it will not allow you to open them, edit them, or view them.
    If it's not practically useful, then it's practically useless.

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

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Well, not without the backwards-compatability patch anyway...
    George
    Home | Blog

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    From what I hear, a nicotine-patch is required as well.
    If it's not practically useful, then it's practically useless.

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

  7. #7
    Join Date
    Oct 2008
    Posts
    9
    DTS is deprecated, use SQL Server Integration Services instead.

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Murat, you can save yourself some time be reading previous posts....
    If it's not practically useful, then it's practically useless.

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

  9. #9
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    To create a new DTS Package in 2005, I simply edit an existing one, and save it with a different name, and viola, new DTS Package to change/edit, works like a charm.

    I'm in SSIS denial mode. I migrated a DTS package to SSIS and all it seemed to do is wrap it in a pretty wrapper, more layers deep than already the too many layers deep (ie ActiveX script in Workflow task).

    Install:

    "DTS Designer for SQL 2000", takes about a minute to install, and look under legacy tab, you need to bring over your packages though, just save them as Structured Storage files .DTS, and open them on the 2005 server, and save to SQL Server.

    http://msdn.microsoft.com/en-us/library/aa544774.aspx
    Last edited by PMASchmed; 10-21-08 at 18:08.

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I too had SSIS denial, but the first step to recovery is to admit you have a problem

    I've toyed with SSIS over the past 3 months and there's no way I'm going back.
    George
    Home | Blog

  11. #11
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by georgev
    I too had SSIS denial, but the first step to recovery is to admit you have a problem

    I've toyed with SSIS over the past 3 months and there's no way I'm going back.
    Will be more like "28 Days Later" than "28 Days" for me.

Posting Permissions

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