SQL Server 2000 DTS Questions


1. In a DTS package, I am using an ODBC connection as a destination
for a transformation task.

The destination table name uses the format
[databasename].[owner].[table name]

When I have modified the databasename within my ODBC
conection via the ODBC manager, I have noticed that the transformation task
is not being
automatically modified to the new database name.

is there any approach to specifying destination tables within a
transformation task generically so that no modifications are required should
the ODBC connection
be modified?

2. DTS seems to hang on to connections after they are deleted from
the design, Is there anyway of fully deleting a connection within DTS?

Yep you make the destination object name "name only"

Using Disconnected Edit

Navigate to your Transform Data Task
Tind the DestinationObjectName property
Modify it to be the [owner].[table name]


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Paul M" <PaulAtCTV (AT) online (DOT) nospam> wrote

Not sure what the second problem is. Paul, could you please describe it in
more detail?

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