Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    19

    Unanswered: removing existing connecitons in a DTS

    is it possible to remove connections created in a DTS?

  2. #2
    Join Date
    Dec 2003
    Posts
    19

    Re: removing existing connecitons in a DTS

    i realized that expressed this way this question is silly, so let me explain myself

    in a dts you can drag and drop a conection to dts working area and doing this an icon representing the connection appears. Now you can easily remove the connection just selecting the icon and pressing Del key.

    But you can also open connection icon properties and select new connection, provide a new name and change connection properties. Doing this way NO connection icon appears but simply another connection is added to connection collection. If you select disconected edit in package right button menu you will see two connections. So there're two connections but only one connection icon. How can you remove the connection without icon?

  3. #3
    Join Date
    Jan 2004
    Location
    Ottawa, Canada
    Posts
    53

    Re: removing existing connecitons in a DTS

    Not silly at all.

    It can be accomplished through VB.

    The connection information is part of the Connections object and can be modified and saved using VB.

    see the thread

    http://www.dbforums.com/t373639.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •