Existing connections are more than actual connections in dts package.

#1

I accidentally renamed my connection (Text source) and now I have two
connections in the list of existing connection (when I add a dynamic
property,I will see them),my old name and the new name.How can I delete the
old one?

Thanks

#2

Add another text file connection
Make it a clone of the one you want to delete.
Delete the connection you just added.

Help?

"RayAll" <RayAll (AT) microsft (DOT) com> wrote

Quote:

I accidentally renamed my connection (Text source) and now I have two
connections in the list of existing connection (when I add a dynamic
property,I will see them),my old name and the new name.How can I delete the
old one?

Thanks

#3

what do you mean by clone? you mean having the same name? Why it is like
this?

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

Quote:

Add another text file connection
Make it a clone of the one you want to delete.
Delete the connection you just added.

Help?

"RayAll" <RayAll (AT) microsft (DOT) com> wrote

I accidentally renamed my connection (Text source) and now I have two
connections in the list of existing connection (when I add a dynamic
property,I will see them),my old name and the new name.How can I delete
the
old one?

Thanks

#4

I don't know how to make it clone of the original conneection.I try to add
another connection using the same name ,it says that the names are unique.It
dosen't let me do that.
Thanks
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

Add another text file connection
Make it a clone of the one you want to delete.
Delete the connection you just added.

Help?

"RayAll" <RayAll (AT) microsft (DOT) com> wrote

I accidentally renamed my connection (Text source) and now I have two
connections in the list of existing connection (when I add a dynamic
property,I will see them),my old name and the new name.How can I delete
the
old one?

Thanks

#5

When you add the connection you open it up and you can choose one of the
two radio buttons

1. New Connection
2. Existing connection

In the dropdown for existing connection you should see your connection

You want #2

Allan

"RayAll" <RayAll (AT) microsft (DOT) com> wrote

Quote:

I don't know how to make it clone of the original conneection.I try to add
another connection using the same name ,it says that the names are unique.It
dosen't let me do that.
Thanks
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:e1cHB%23xPFHA.3716 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
Add another text file connection
Make it a clone of the one you want to delete.
Delete the connection you just added.

Help?

"RayAll" <RayAll (AT) microsft (DOT) com> wrote

I accidentally renamed my connection (Text source) and now I have two
connections in the list of existing connection (when I add a dynamic
property,I will see them),my old name and the new name.How can I delete
the
old one?

Thanks

#6

Thanks ,it worked out.
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

When you add the connection you open it up and you can choose one of the
two radio buttons

1. New Connection
2. Existing connection

In the dropdown for existing connection you should see your connection

You want #2

Allan

"RayAll" <RayAll (AT) microsft (DOT) com> wrote

I don't know how to make it clone of the original conneection.I try to
add
another connection using the same name ,it says that the names are
unique.It
dosen't let me do that.
Thanks
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:e1cHB%23xPFHA.3716 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
Add another text file connection
Make it a clone of the one you want to delete.
Delete the connection you just added.

Help?

"RayAll" <RayAll (AT) microsft (DOT) com> wrote in message
news:RayAll (AT) microsft (DOT) com:

I accidentally renamed my connection (Text source) and now I have two
connections in the list of existing connection (when I add a dynamic
property,I will see them),my old name and the new name.How can I
delete
the
old one?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Existing connections are more than actual connections in dts package.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Existing connections are more than actual connections in dts package. - 04-11-2005 , 05:56 PM

Re: Existing connections are more than actual connections in dts package. - 04-12-2005 , 12:27 AM

Re: Existing connections are more than actual connections in dts package. - 04-12-2005 , 12:43 AM

Re: Existing connections are more than actual connections in dts package. - 04-12-2005 , 10:20 AM

Re: Existing connections are more than actual connections in dts package. - 04-12-2005 , 01:23 PM

Re: Existing connections are more than actual connections in dts package. - 04-12-2005 , 02:35 PM