I have seem to have extra Connections that are visible in Drop-downs, etc,
and although no tasks are using these connections, I can't seem to get rid
of them.

An easy way to duplicate this is to 'Copy/Paste' a connection in the
designer. You'll end up with 'Connection 1 Copy' or something similar.

Any ideas?

Add another connection | Assign it as the one that appears to be missing in
the drop down (Existing Connection) | delete the connection

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Harry F. Harrison" <Harry_Harrison (AT) sbcss (DOT) k12.ca.us> wrote