Point DTS pkg to renamed database?

[stnkyminky]

We're currently going through a migration to a newer ERP system. Using the driver provided by the company, I've created many DTS packages to transfer data from the ERP box to Sql Server.

As a test bed I created a database called test. During the creation of the DTS pkgs, I specified the destination to this database. Before the cut over happens, I want to rename the database to replace the we are using now. Currently the DTS pkgs are trying to import data into the test database.

Is there a way that I can rename the test database and have all of the pkgs, importing data into it, point to the new database?


Scott
Programmer Analyst
<{{><

 

[JayKusch]

I do not beleive there is one point in the package to change the DB assignment. If you have set up you package to use a user defined variable as the Destination DB, you could have set it to "test" in the testing phase and then "LiveDB", for example, when you were cutting over to the live server and DBs.

If you did not use a variable, you will need to change the Destination DB in each of the connections that are used in the package. You may also need to re-establish the transformations when you change the DB designation.

Thanks

J. Kusch

 

[jelf]

If this a once only task why not just run it and then rename your test database.