################################ Package Installation Wizard #############################
installing your SSIS project onto a new server.
################################ Business Intelligence Development Studio ################
Business Intelligence Development Studio (BIDS)
################################ The SSIS Package Designer #########################
In the Evaluation Operation drop-down box, you can edit how the task will be evaluated.
Constraint: Evaluates the success, failure, or completion of the predecessor task or tasks
Expression: Evaluates the success of a customized condition that is programmed using an expression
Expression and Constraint: Evaluates both the expression and the constraint before moving to the next task
Expression or Constraint: Determines if either the expression or the constraint has been successfully met before moving to the next task
If you select Expression or one of its variants as your option, you'll be able to type an expression in the Expression box. An expression is usually used to evaluate a variable before proceeding to the next task. For example, if you want to ensure that Variable1 is equal to Variable2, you would use the following syntax in the Expression box:
@Variable1 == @Variable2
Task Grouping:
Variables:
There are two types of variables: system and user.
Executing a Package:
To get back to design mode, you must click on the Stop icon on the debugging toolbar, press Shift+F5, or choose Debug Stop Debugging.