is it possible to remove connections created 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?|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment