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
543 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 ...
This blog shows a clever way to annotate expression constraints in SSIS |
---|
If you've added an expression constraint to control flow in a package in Integration Services, this blog will show you how to display what the constraint does automatically. |
In this blog
So thanks to Nick from my course this week for this tip!
Suppose that you have an expression constraint, which will only let SSIS proceed to archive a file if you've imported at least ten rows from it:
The expression constraint shows up as fx.
Here's what this expression constraint looks like:
Assume that NumberRows is a variable which holds ... the number of rows imported.
So until this week, I'd thought that this was about the only case in SSIS where it's worth creating an annotation:
You can right-click to add annotations to control flow diagrams, but the annotation won't move as you drag tasks around.
A better idea is to right-click on the line joining the tasks, to change its properties:
Right-click on the joining line, and choose Properties as shown.
Choose one of these options:
See below for the annotation options.
Your choices are:
Option | What it will show |
---|---|
AsNeeded | Show the fx symbol only. |
ConstraintName | The Name property (Must have at least 10 rows in the above example). |
ConstraintDescription | The Description property (hidden in the above diagram). |
ConstraintOptions | The full expression entered (see example below). |
Never | Nothing at all. |
Here's what you'd see for a couple of choices:
ConstraintName | ConstraintOptions |
Although the option on the right is dynamic (the package will always display the latest expression), it looks a bit messy!
Chouette!
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.