January 23, 2007 at 10:03 am
Anyone know of a way to lock the connections on a SSIS diagram in place, so they don't move? After arranging a large diagram to it was logical and legible, I closed my project. I was disappointed to find everything went to **** when I reopened the package.
January 29, 2007 at 10:50 pm
The only 'connections' I can think of is the 'connection managers' pane in 'control flow' tab for a SSIS project. In that case, depending on how you sized the pane, it will automatically list your connections in a vertical or horizontal manner!
January 30, 2007 at 7:52 am
I'm speaking about the 'connection' you would drag from the first task in the package to the second task in the package. In the CONTROL FLOW window, they're called 'precedence constraints'. I want to lock them down so they don't move when I reopen a package.
I have reorganized some of my more complex packages so they are easier to read, but once I close and reopen the package, these precedent constraints have moved back to where they originally were.
January 31, 2007 at 4:04 pm
OK. I think this is a quirk with SSIS, similar to applications like ERWin when it comes to preserving the positioning of the 'connectors'. My advise would be to either (i) not to worry too much about it, or (ii) use sub-packages and/or sequence containers to modularise your package so that it doesn't look too cluttered on the diagram.
P.S. A sequence container has the minimise component icon (looks like two up arrows) which you can use to good effect.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply