Post reply

unable to view dts packages under Data Transformation services in SQL 2005

  • November 3, 2010 at 10:37 am

    #142324

    I have migrated all DTS packages from 2000 to 2005 but i am unable to see them under lagacy- Data Transformation services. I can see all the packages under SSIS. I can even open a pakcage that i copy to the 2005 server and edit but unable to view under lagacy-DTS.

    Any Idea???

  • November 11, 2010 at 1:49 am

    #1249315

    My initial thought is you might be mistaking terms..

    DTS Packages that are migrated are turned into SSIS packages and therefore would not be under the legacy DTS packages they would be in the SSIS package list.

    Migrated DTS packages almost always need some TLC before they are "right" again.. There are only a few packages that do a good job with them DTS xChange is one of the best.

    So the question I have is what did you do to the jobs and what was your expectation of whatever you did?

    CEWII

Viewing 2 posts - 1 through 2 (of 2 total)

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