Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to keep SSIS constraint lines neat?

In SSIS, if I start with one step, then have a lot of steps that can happen all at once, and then have another single step after all of those are done, the constraint lines are all over the place. It's ugly and that makes it hard to read. I can move them around, but the next time I load the package, they are ugly again. Is there a way to make them stay where I put them, so I can keep this looking neat?

Here is a partial picture of what I am talking about (This graphic doesn't show up for me).Lots of ugly lines

Lacking the graphic, here is an example in words:

step 1: start a log file 
step 2 (10 of them): load file 1 through load file 10 
step 3: create a flag file 
step 4: ftp all the files to another location
like image 602
thursdaysgeek Avatar asked Mar 21 '11 18:03

thursdaysgeek


2 Answers

They should stay put, i think that you've got a bug there. You can use Format > Auto Layout every time you open it to make it more readable, but that's really just a workaround.

like image 177
DKnight Avatar answered Nov 15 '22 08:11

DKnight


Move your 10 tasks in step 2 into a sequence container. Drag line from step 1 to sequence container. Drag line from sequence container to step 3.

You don't need any lines between the 10 tasks (if they are to be run in parallel in whatever order ssis chooses). You'll end up with one line from step 1 to sequence container, and one line from sequence container to step 3.

like image 40
cairnz Avatar answered Nov 15 '22 08:11

cairnz