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.
Also, I have installed the DTS Designer 2000 but how to work with it in MSS Management Studio?
In Theory, theory and practice are the same...In practice, they are not.