Hello,

I've created a DTS with 2 data sources.
Now I wanted to rename one of the data sources so I have to create a new
one.
How can I delete the old DS? (It appears in the object's list)

Bye

So you have a package with a Source Connection and a destination connection. You wanted
to rename so you highlighted the datasource you no longer wanted and hit delete but it
still remains in the list? What list?

Do you refer to the list of avaliable data sources "Existing Connection"



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

On Tue, 30 Aug 2005 10:54:31 -0300, "Eugenia" <msdn (AT) rmya (DOT) com.ar> wrote:

Use DisconnectedEdit.

U¿ytkownik "Eugenia" <msdn (AT) rmya (DOT) com.ar> napisa³ w wiadomo¶ci
news:ujsc0qWrFHA.3080 (AT) TK2MSFTNGP15 (DOT) phx.gbl...

I opened disconnectedEdit but I didn't find any option to delete the Data
Source, even with the right button.

"Marcin Pêksa" <mpeksa (AT) poczta (DOT) onet.pl> wrote

Drag a new connection onto the designer. Select the old
connection name you want to delete in the Existing
connection drop down. Click OK to save this connection. Then
delete this connection you just created. It will delete the
old connection name reference with it.

-Sue

On Thu, 1 Sep 2005 18:05:54 -0300, "Eugenia"
<msdn (AT) rmya (DOT) com.ar> wrote:

Thanks, Sue.

I could delete the old connections!!

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote