"Paul M" <PaulAtCTV@online.nospam> wrote in message
news:uI4e6Y2kFHA.3300@TK2MSFTNGP15.phx.gbl...
> 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?
>
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23GmjQz6kFHA.2396@TK2MSFTNGP12.phx.gbl...
> 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@online.nospam> wrote in message
> news:uI4e6Y2kFHA.3300@TK2MSFTNGP15.phx.gbl...
>> 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?
>>
>>
>>
>
>