SQL Server Performance Forum – Threads Archive

DTS Migration Tool

Hi , Anyone used the Dts migration tool. Yesterday i try to migrate my Sql 2000 DTS packages to SQL 2005. aand i got an error "Index out of range.. bla bla bla" Could not migrate when choosing source SQL Server and Destination SQL Server. I had to migrate manually one by one[<img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ />!] (70 packages in all) Any one has an idea why?[<img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ />] AKTHAR

Yes I did use. But it gave me lots of problems. So I had to re-design all the DTs packages agins for SQL server 2005 —————————————-

Well i guess it it not yet ready for use[V] But i have use the migration wizard but as source i have use the DTS file. This works but you cannot choose all DTS you have to choose one by one[<img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ />!] AKTHAR

hi akhtar,
Even i had problems in migrating, for that reasons, i had asked you for the same in some other thread.

hi ranjit, Hav you tried to migrate manually from DTS Struc Storage file (.dts)???
AKTHAR

]]>