|
Home > Archive > MS SQL Server DTS > July 2005 > SQL2000 DTS help
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Paul M 2005-07-28, 7:23 am |
| 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 2005-07-28, 8:24 pm |
| Yep you make the destination object name "name only"
Using Disconnected Edit
Navigate to your Transform Data Task
Tind the DestinationObjectNam
e 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?
>
>
>
| |
|
| Not sure what the second problem is. Paul, could you please describe it in
more detail?
"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 DestinationObjectNam
e 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...
>
>
|
|
|
|
|