SQL Server Performance

DTS upgraded from SQL Server 2000 to 2005

Discussion in 'SQL Server 2005 General Developer Questions' started by dineshasanka, Jan 2, 2006.

  1. dineshasanka Moderator

    I upgraded DTS SQL Server 2000 from SQL Server 2005 by using Migrate Wizard in SQL 2005. But How can I view those DTS from SQL Server 2005

    ----------------------------------------
    http://spaces.msn.com/members/dineshasanka
  2. Luis Martin Moderator

    Managment Studio--->Managment--->Legacy----DTS.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  3. dineshasanka Moderator

  4. Luis Martin Moderator

    I had similars problems, some times work well, some times I have to create DTS from the begining.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  5. dineshasanka Moderator

    Opps. not sound great.<br /><br />I have 150 odd DTS. [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br />----------------------------------------<br /<a target="_blank" href=http://spaces.msn.com/members/dineshasanka>http://spaces.msn.com/members/dineshasanka</a><br />
  6. dineshasanka Moderator

    Luis,
    I found another way,
    Rather than using the upgrade wizard, if you copy the SQL Server 2000 DTS into dts file and do a import in SQL 2005 it works

    ----------------------------------------
    http://spaces.msn.com/members/dineshasanka
  7. dineshasanka Moderator

Share This Page