560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls 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
|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.|
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:
What it will show
Show the fx symbol only.
The Name property (Must have at least 10 rows in the above example).
The Description property (hidden in the above diagram).
The full expression entered (see example below).
Nothing at all.
Here's what you'd see for a couple of choices:
Although the option on the right is dynamic (the package will always display the latest expression), it looks a bit messy!
25 Aytoun Street