I have a number of DTS packages that I have written (with the help of this forum) to perform a data migration exercise.

I have a problem however in that I want to run these packages on different databases without having to go through each script changing the connection script and then each script Destination table to point to the new database (same table name just different database name).

I have looked at global variables but these don't seem to fit the bill. Does anyone know how I can parameterise the connection database and have this feed through into the Destination tables of each script in that package?

I'm quite happy to be pointed to a reference manual or command set in order to figure it out myself.

Cheers
Adrian