Hi.. We currently have SQL2K running in WinNT. We are migrating the Windows OS to 2003. And as SQL 2K will not work and support on Win2K3, we are to upgrade the SQL from 2K to 2K5 as well. I dont seem to have any issues with the DB Engine. Can any one kindly help to let me know how can we migrate the DTS from SQL2K to SQL2K5 from DB wise and using flat files as well. In another scenario, we have uninstalled the sql server and hence the DTS tables cannot be inherited from the msdb DB from that server. However the same set of DTS is present in its Prod server. How can we migrate the DTS from that server? Any responses appreciated. Thanks..

Hi, The thing is with DTS v SSIS is that it was a complete code re-write, and they are not 100% compatable. There is an upgrade wizard, but this only works for pretty basic packages. IMHO, you should re-write the packages. This will also allow you to take advantage of the improved SSIS Architecture.Peter Carter http://sqlserverdownanddirty.blogspot.com/ MCT MCITP: SQL Server 2005 & 2008 Admin, Dev & BI Microsoft Community Contributor