I created a DTS package which loads data from Access to SQL Server. It will
be used in 15 different databases. The table names are exactly the same in
each database. As I rolled out the package to each database, I changed the
connection object to point to that database. I also had to go into each
transform data task and change the database names.

From: "SvcReports_10"."dbo"."tblBranches"
To: "SvcReports_20"."dbo"."tblBranches"

Is there a way or maybee a utility that can mass change the transform tasks
from database SvcReports_10 to SvcReports_20 ?

Look into the Dynamic Properties task. One way to set the connection
is through a package global variable. If this is set as a job, alter
the parameters in DTSRunUI and generate the command.

Marty


rmcompute wrote: