Renaming Connections in DTS

Question

Renaming Connections in DTS

Ivy

SSC-Addicted

Points: 479
More actions
November 26, 2002 at 9:55 am

#105972

Can you rename connections in a dts package. I go into disconnected edit and change the description and name, yet it still says the other name underneath that connection object?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ewilson10 SSCarpal Tunnel Points: 4255 More actions · Answer 1

Yes you can, and it's done by changing the description (which you did). The only thing I'm not sure of in your description is 'going into disconnected edit'. Maybe this is having a negative effect.

Everett Wilson
ewilson10@yahoo.com

philcart SSC-Forever Points: 47794 More actions · Answer 2

When you're in Disconnected Edit, make sure you change the task that is associated with the step as well.

Thanks

Phill Carter

Edited by - phillcart on 11/26/2002 5:15:10 PM

--------------------
Colt 45 - the original point and click interface

Ivy SSC-Addicted Points: 479 More actions · Answer 3

The answer was, after you edit the names in disconnected edit, you have to open each connection object and click ok..this will update the name underneath the connection object.

Lane Tharp SSC Enthusiast Points: 128 More actions · Answer 4

Simple solution.

1. Go to edit connection properties.

2. Select New Connection Option. (Connection parameters stay the same.)

3. Type the new name.

4. Press OK.

The old connection will disappear when no longer used by any task upon closing or recreation of the package.

Lane Tharp SSC Enthusiast Points: 128 More actions · Answer 5

My last post was innacurate. The unused connections remain even though they are unused. I have posted an ActiveX script that cleans up unused connections.

Best of luck!