1.

How many types of variables are there in SSIS?

Answer»

There are broadly two DIFFERENT types of variables in SSIS. They are:

  • System Defined: SSIS provides a SET of system variables to store the information regarding running packages and objects. They are generally used in expressions and PROPERTY expressions to customize containers, event HANDLERS, packages, and tasks.
  • User-Defined: These types of variables can be configured by the user in a way that its value can be updated at the run time, or the value can be ASSIGNED by the user itself at the time of creation.


Discussion

No Comment Found