Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
538 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
How to lay out diagrams in SSIS packages to look neat |
---|
Arrows in your Integrated Services packages can go all over the place - learn how to control them in this short blog on formatting SSIS diagrams. |
If (like me) you're a bit anal about getting your control or data flow diagrams to line up properly, help is at hand!
The diagrams below come from SSIS 2012, but the menus are identical in 2008 R2.
So let's say that you have a diagram which looks unpleasant (and not just because of all the red crosses showing that this lazy blogger hasn't validated his tasks):
A messy control flow diagram.
A good first step might be to auto-format it:
Choose this option from the Visual Studio menu.
The results may or may not be seen as an improvement:
Auto layout tidies up your diagram - usually.
Alternatively, you can align and space things. For the above diagrams, the final two tasks should have the same height and be aligned. To achieve this, first select them:
Click and drag to draw a rectangle touching or enclosing the tasks you want to select.
You can also use the CTRL key to add tasks to the current selection.
You can now make them the same height (and align them) using these menu options. First make the selected tasks the same height:
Choose this to make two or more selected tasks all have the height of the tallest.
Now you can align the tasks by their top edges:
Choose this option to align the tasks by their top edges.
The results - if you're a tad anal - is task perfection:
Much better!
There are various other options you can explore on the Format menu, to make your diagrams line up to your satisfaction!
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.