My development group has an install program that allows
the user to change the default db name to anything they
want. I need to migrate some Access Data (.mdf file)
from the user's hard drive to the installed database
(always a SQL 2000 db) as the destination database for my
DTS package. The source Access db will remain constant
and is not an issue as it is copied to a directory and
controlled by the install program. My quandry is what to
do if the database name is changed at installation. How
do I dynamically alter the database name for my
destination data source. Any help is appreciated.
Thanks,
Lance

In article <05e201c39356$0e426a50$a301280a (AT) phx (DOT) gbl>, Lance McCaskey
<lmccaskey (AT) riag (DOT) com> writes
Changing the DataPump Source and Destination Tables
(http://www.sqldts.com/default.aspx?213)

Note the table name by default uses the three part form, so this covers
the DB too. You need to pass the DB name into the package, preferably as
a global variable or else read it from within the package. If you edit
the object to remove the BD name on the DataPump then you can just
change the connection instead, but by default the object name includes
the DB, but this is not required.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thanks Darren. I'll give it a shot.