I add an SQL-Server Connection (database: db1), and an ODBC - Connection
(using a system-dsn) to an dts package. Now I add an Data-Transform Task
witch uses the ODBC-Connection as the target-connection and the ODBC
Connection as the destination connection. The desination table is set to
"table1".
All works fine, but:
If I change the Database of the SQL-Server Connection to db2 (witch has an
identical structure), the Data-Transform Task uses "db1.table1" as the
destination table, instead using the table1 of the db2!
This is a problem, becaurse there are 30 Data Transformation Tasks depending
on the SQL Server Connection. If I want to target db2, I must change the
table in each Data Transformation Task!

any ideas?

thanks, GP

Use disconnected edit (DestinationObjectName) to make it name dependent
only. This, you are correct is annoying, but can using the method given be
overcome.

--
--

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

"Günter Prossliner" <gpointprossliner (AT) removegmx (DOT) at> wrote