DTS upgraded from SQL Server 2000 to 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS upgraded from SQL Server 2000 to 2005

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

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.
Yes I tried it. but there are no dts there. when I tried to import it again it asks me to over write —————————————-
http://spaces.msn.com/members/dineshasanka

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.
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 />
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

Creating the DTS from the beggining is the best way I suppose —————————————-
http://spaces.msn.com/members/dineshasanka

]]>