I have a simple dts package that copies data from one table to another
(deleting rows in the destination table) for about 20 tables. The source
database will always be the same but I'd like the ability to quickly change
all references to the destination database for the deletion and insertion.
How can this be accomplished? I tried changing the connections in the
disconnected edit section but that didn't do the trick.

The destination database is referenced by a connection object yeah? You
would need one of these if using the Datapump task or the ExecuteSQL task.
If that is the case and they all use the same connection object then you
only need to change things in one place

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

Did you resolve this problem?

I'm attempting to implement the same multiple destination
functionality in my package.

Shawn

Email: slovelid (AT) jcpenney (DOT) com

You also need to look at the DestinationObjectName property of the DataPump
tasks.

--
--

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

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