DTS Connections

#1

My question relates to connections in SQL Server 2000 SP3

I have a number of unused connections in my DTS package, some of which
are causing problems (packages to fail and Enterprise Manager to
crash). I have removed all references to these connections (in SQL
tasks, for example) and removed all icons. I would like to delete them
completely but I cannot seem to do it, i.e. when I create a new
connection or task, these old connections are still referenceable. How
can I get rid of them?

Thanks,
Nick

#2

Hello nick,

Create new connections that are based on the "non Existent" connections and
then delete the connections that you just created.

Does this help?

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

My question relates to connections in SQL Server 2000 SP3

I have a number of unused connections in my DTS package, some of which
are causing problems (packages to fail and Enterprise Manager to
crash). I have removed all references to these connections (in SQL
tasks, for example) and removed all icons. I would like to delete
them completely but I cannot seem to do it, i.e. when I create a new
connection or task, these old connections are still referenceable.
How can I get rid of them?

Thanks,
Nick

#3

Hello Allan,

Quote:

Hello nick,

Create new connections that are based on the "non Existent"
connections and then delete the connections that you just created.

Does this help?

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com
My question relates to connections in SQL Server 2000 SP3

I have a number of unused connections in my DTS package, some of
which
are causing problems (packages to fail and Enterprise Manager to
crash). I have removed all references to these connections (in SQL
tasks, for example) and removed all icons. I would like to delete
them completely but I cannot seem to do it, i.e. when I create a new
connection or task, these old connections are still referenceable.
How can I get rid of them?
Thanks,
Nick

Exactly how you do that is covered here -

Removing unwanted or orphan connections from a package
(http://www.sqldts.com/default.aspx?253)

#4

Thanks guys, sounds pretty simple! I will try this tomorrow.

Nick

Darren Green wrote:

Quote:

Hello Allan,

Hello nick,

Create new connections that are based on the "non Existent"
connections and then delete the connections that you just created.

Does this help?

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com
My question relates to connections in SQL Server 2000 SP3

I have a number of unused connections in my DTS package, some of
which
are causing problems (packages to fail and Enterprise Manager to
crash). I have removed all references to these connections (in SQL
tasks, for example) and removed all icons. I would like to delete
them completely but I cannot seem to do it, i.e. when I create a new
connection or task, these old connections are still referenceable.
How can I get rid of them?
Thanks,
Nick

Exactly how you do that is covered here -

Removing unwanted or orphan connections from a package
(http://www.sqldts.com/default.aspx?253)

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

DTS Connections

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

DTS Connections - 06-20-2006 , 11:03 AM

Re: DTS Connections - 06-20-2006 , 01:24 PM

Re: DTS Connections - 06-20-2006 , 04:43 PM

Re: DTS Connections - 06-21-2006 , 03:38 AM