Re: Removing connections from a package

#1

Drag a new connection onto the designer. Select the old
connection 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 reference with it.
You can get these orphaned connections when you rename
an existing connection.

-Sue

On Fri, 12 Sep 2003 06:37:23 -0700, "Jamie Thomson"
<jamie.thomson (AT) int21 (DOT) com> wrote:

Quote:

Hi,
[Still on a learning tip].

Its easy to delete a connection from a package (right-
click, Delete) but when you look at the disconnected edit
utility any connection that has been deleted still exists
as part of the Connections collection.

How do you remove a connection from a package permenantly?

I've tried something like:

myPackage.Connections("<connection_name>").Remove

but that doesn't work.

How can I do it?

Following on from this...
Is there a book that is a complete reference guide to the
DTS Object model - objects, properties and methods? I use
Tim Peterson's book (and this newsgroup) as my DTS
reference material and it is very good, but it doesn't
give a clear overview of the DTS Object Model. I would
have hoped it would have included it as an appendix or
something.

I'll go and check out www.sqldts.com now and see if
there's anything on there.

Regards
Jamie

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

Re: Removing connections from a package

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

Re: Removing connections from a package - 09-12-2003 , 08:56 AM