I have a DTS package that copies data from tables in one database to the
same tables in another database, deleting records in the destination tables
first. How can I easily change the source and destination database
references throughout the DTS package so I can reuse the DTS package
elsewhere? All the tables will be the same.

Have a look at this

Connections
(http://www.sqldts.com/default.aspx?101)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"David Morrison" <me (AT) nospam (DOT) com> wrote

I don't really see anything there that addresses this question. I'm working
with SQL Server databases, not Access. There are a bunch of references to
code but I'm not a programmer. I'm looking for a place in SQL Server
Enterprise Manager where I can alter the DTS package so that it will look to
different databases.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

You add global variables to the project for the server
name and the database name. Then you add a Dynamic
Properties task (look for Dynamic Properties Task in the
bol index). You find where the server name is used and
set the property from the global variable.

Russ Loski, MCSD
www.LoskiDataMovers.com

That sounds good. I'll look into it. Thanks!

"RLoski" <anonymous (AT) discussions (DOT) microsoft.com> wrote

OK. The concept is the same it just doesn't have Your exact circumstances.
If you are using SQL Server 2000 you have an array of options but the
Dynamic Properties task is as good a task as any. You assign a value from an
external source to the DataSource AND/OR Catalog properties of your SQL
Server connection. That external source ranges from an INI file to a
database query.

Have a look.



--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"David Morrison" <me (AT) nospam (DOT) com> wrote