DTS Migration Tool | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Migration Tool

Hi ,<br /><br />Anyone used the Dts migration tool.<br /><br />Yesterday i try to migrate my Sql 2000 DTS packages to SQL 2005. aand i got an error <br /><br />"Index out of range.. bla bla bla"<br />Could not migrate when choosing source SQL Server and Destination SQL Server.<br /><br />I had to migrate manually one by one[<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />!] (70 packages in all)<br /><br />Any one has an idea why?[<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />]<br /><br />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]<br /><br />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=’:(‘ />!]<br /><br />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
]]>