SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Container Connectors more user friendly?


SSIS Container Connectors more user friendly?

Author
Message
CptCrusty1
CptCrusty1
Old Hand
Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)

Group: General Forum Members
Points: 316 Visits: 387
I know, I'm completely Anal about this stuff; however, I don't like the connectors between the containers to be overlapping the container. It makes it harder to read/understand. I like my SSIS packages to be neat and tidy. I've tried several things to keep the connecter where I want it, but it always moves itself over other containers. How do I make them behave?

Thanks
Crusty
Ray M
Ray M
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2127 Visits: 1076
I'm not as OCD about where the connectors go, I also try to understand that the SSIS GUI is not intended to be Visio. Other than providing tons of Space between Containers, You can use Sequence Containers (which Can collapse) to organize chunks of logic together. also Like to use the Allignment Tiles from the Layout toolbar to make sure tops/Middles are alligned so the lines are straight. Other than that not much to do it is annoying when its very busy, and every time you open it, the lines are not in the same place.
CptCrusty1
CptCrusty1
Old Hand
Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)

Group: General Forum Members
Points: 316 Visits: 387
Thanks.. However, I don't see a "Sequence" Container and since everything is alphabetical, clearly that means I'm missing something.

I used a Data Flow task that didn't do anything and put a couple of them out in midair to clean it up. Is that essentially the same thing?
Ray M
Ray M
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2127 Visits: 1076
Not really.

If you click the control flow tab, in the toolbox under Control Flow Items, I see it as the fourth item, "Sequence Container"

http://www.bidn.com/blogs/TomLannen/bidn-blog/2620/using-sequence-containers-in-ssis

It #1 Contols Flow, Logical blocks of containers (SQL Tasks, Script Tasks, DataFlow Tasks) That must all succeed for Sequence container to Succeed.) Not necessarily there for organization. I commonly use it on larger packages.
Its also nice that you can collapse the sequence container for more screen real estate.
CptCrusty1
CptCrusty1
Old Hand
Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)

Group: General Forum Members
Points: 316 Visits: 387
Ray M (11/20/2012)
Not really.

If you click the control flow tab, in the toolbox under Control Flow Items, I see it as the fourth item, "Sequence Container"


In the infamous words of Homer Simpson....

D'OH!!!w00t

I looked right at it and didn't see it.... I'ma gonna puttit enna dar right-a now!!

Thanks Dude.
CptCrusty1
CptCrusty1
Old Hand
Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)

Group: General Forum Members
Points: 316 Visits: 387
Ok. Anudder dumb question. I dropped some already existing containers into the Sequence Container. When I collapsed the Sequence container, all the Arrows were still visible, but everything collapsed. Any idea whats causing that? I even deleted them all, and started redoing them, no change. The only thing I can think of is that they're in groups, within the sequence container....

Crusty.
Ray M
Ray M
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2127 Visits: 1076
The sequence container provides a logical grouping.
If I collapse a sequence container all containers within are collapsed and I do not see any arrows.
I see arrows To other containers outside of the sequence container, which are connected as part of the control flow.

You need to make sure the container is dragged into the sequence container.
Sometimes they are in front or behind, but not within. which sounds like what your describing.
CptCrusty1
CptCrusty1
Old Hand
Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)

Group: General Forum Members
Points: 316 Visits: 387
It actually has something to do with the fact that I grouped things first. If I collapse the group first, then collapse the container, the whole thing buttons up nicely... its weird, but it works.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search