Upgrade path gap? You cant get there from here?

  • Im afraid that upgrading SBS/SS2K5 to Windows 2008 and SS2K8R2 has a gap involving unmigrated legacy dts packages because the ss2k5 that shipped with sbs

    (Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86) Mar 25 2011 13:50:04 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    did not include ssis, so they have been running unmigrated dts pkgs under the legacy folder.

    More ram is getting added to the sever, the os is getting changed to windows server 2008 and sql server 2008 R2 is getting installed, but the packages are still unmigrated dts.

    Once the .dts files are copied over to the new installation, will the dts packages be operable in the new environment?

    Will whatever is scriptable out of them be movalbe into BIDS once its installed so we can convert them to proper ssis packages?

    thanks very much

    drew

  • I apologize that this post is of no help in solving your problem other than maybe "bumping" your post for you. I just wanted to make the observation that this is yet another reason why I try to do as much as possible using only T-SQL. Even advertised and supported features such as DTS really take it in the shorts when new revisions of SQL Server come out.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • DTS still works in SQL 2008. May not in the next version...

    They're not openable in BIDs, download the DTS designer from the resource pack site and you can open them in Management Studio.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Jeff Moden (8/16/2011)


    **** Even advertised and supported features such as DTS really take it in the shorts when new revisions of SQL Server come out.

    call me schtummie, but i was very disappointed when English Query disappeared.

  • GilaMonster (8/17/2011)


    DTS still works in SQL 2008. May not in the next version...

    They're not openable in BIDs, download the DTS designer from the resource pack site and you can open them in Management Studio.

    Thats what i wanted to hear; well, not really, but at least the situation hasnt detetrioriated beyond what it was.

    Dont ask if things can get worse because they can.

    thanks a lot Gail

    drew

  • There is some extra configuration you must do on SQL 2008 R2 to get DTS Designer work - some files must be copied but this is all documented in BOL.

    I also advise you download the free 'DTS Backup 2000' to help move your DTS packages. It is the only method I know of that maintains the DTS designer layout and annotations during the move process. The standard Microsoft export/import looses both of these.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • thanks very much; i'll do that.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply