Sorin Petcu (2/1/2008)
I 've used the Migration Wizard for my DTS packages and it was worked well. But, my new server and database server have different names from the old one. So I have to change the connections from inside every package. How to do that? How to edit the packages since they are already imported in SQL 2005 SSIS? I've tried with BI but there is no deploy option to deploy the package to SSIS repository where my packages are stand on.
I've not had any experience migrating DTS to SSIS, however in the migration options is there no option to migrate to file rather than SQL Server?