2

I recognize that these are variables, but I am not sure how to add these elements to the package (or how they are added to begin with), what effect that have or even how to manipulate them. No right click, no left click. I can hover the mouse over the element and the tooltip displays the variable name.

I can add variables via right click > Edit > Parameter mapping...however that does not display the little icon on the various control flow elements.

enter image description here

enter image description here

I am trying to rebuild this SSIS package. I have very little experience with MS Visual Studio/SSIS/SQL. Thanks for any input.

0

1 Answer 1

2

The fx glyph indicates that an Expression exists on the item in reference. The first picture indicates there is a an expression on the Precedent Constraint between two items. Whether they're backed by Variables or hard coded won't be known until you explore.

The blue color I think is that the preceding task must finish (Completion) - failure or success does not matter. The red dashed line coming in from offscreen is the Error/Failure path from a Task.

The Dashed line indicates that there is a Logical OR condition between all the elements that feed into the icon offscreen. A solid line will indicate a Logical AND condition.

Double click the blue precedent constraint and you'll see something like this

enter image description here

You can also right click on anything and select properties. An element like a Precedent Constraint will look like this

enter image description here

More complex tasks will have the Expressions in their own section i.e.

enter image description here

All that said, you should be able to add the package to an existing SSIS project and Visual Studio will upgrade it to the current revision. There can be hiccups with things like script components which are usually resolvable by opening up the script and rebuilding. Other things, like custom third party components, need to be updated to bind to the current version of SQL Server binaries.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.