Geeks With Blogs
Baskar B.V SQL - BI Consultant

Hi,

We might have used udls connections in DTS package and forgot to delete unused ones.  This might happen when we copy existing DTS package and modify the udls by editing them and creating new connections. This would pile up a list of unused connections in the DTS package. This tip explains how to delete these unused udl connections.

  1. Create a new UDL connection by dragging it from the task window.
  2. Instead of creating new connection click on existing connection and select the unused one from the dropdown which you want to delete.
  3. After selecting 'Ok' to the task, immediately delete that task. This would delete the connection too.

HTH.

Posted on Sunday, November 25, 2007 5:26 PM | Back to top


Comments on this post: Deleting unwanted UDL connections in DTS package

# re: Deleting unwanted UDL connections in DTS package
Requesting Gravatar...
Great Tip.
Left by Revin on Apr 08, 2008 4:40 PM

# re: Deleting unwanted UDL connections in DTS package
Requesting Gravatar...
It works fine.

Thanks.
Left by David on Oct 30, 2008 10:03 AM

# re: Deleting unwanted UDL connections in DTS package
Requesting Gravatar...
Just what I needed. Ta.
Left by Rob on Mar 07, 2009 7:24 AM

# re: Deleting unwanted UDL connections in DTS package
Requesting Gravatar...
Good Tip, I will check it.
Left by Moorthy on May 11, 2009 6:40 AM

# re: Deleting unwanted UDL connections in DTS package
Requesting Gravatar...
You sure are a life saver. Thx :)
Left by Jay on Sep 06, 2011 3:54 PM

# re: Deleting unwanted UDL connections in DTS package
Requesting Gravatar...
it works fine for me .. thanks a lot !!!
Left by dattatray shinde on Aug 09, 2012 5:55 AM

Your comment:
 (will show your gravatar)


Copyright © Baskar B.V | Powered by: GeeksWithBlogs.net