Personal Notes of Edwin Eu

Archive for the ‘SSIS’ Category

SSIS – Precedence Constraint Editor

In SSIS on 06/12/2012 at 4:08 PM

A precendence constraint has the evaluation operations:

  • 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.

SSIS – The Precedence constraint

In SSIS on 06/12/2012 at 3:57 PM

The precedence constraint arrows can have different colors  to represent different commands. Each color represents a status when a task executed.

  • Green = On Success
  • Red = On Failure
  • Blue = On Completion
  • Any color with FX Logo = Expression, or Expression with a Constraint

SSIS – Protection Level

In SSIS on 06/12/2012 at 3:39 PM

The SSIS Protection Level has:

  • DontSaveSensitive
  • EncryptSensitiveWithUserKey
  • EncryptSensitiveWithPassword
  • EncryptAllWithPassword
  • EncryptAllWithUserKey
  • ServerStorage