What's the difference between a parameter and a variable in SSIS 2012?

3.7k views Asked by At

This is an interview question.

"What is difference between Parameter and variable in SSIS 2012?"

I am confused about what the actual difference is between them.

1

There are 1 answers

0
siddhartha jain On
  • Variables are local to the environment while Parameters are not.
  • Variables in different Environment are independent of each other.
  • A parameter specifies the data that will be used by a package. You can scope parameters to the package level or project level with package parameters and project parameters, respectively.
  • Values to different variable can be supplied through parameters

For Example - In terms of OOPS, I can say variable are private entities while Parameters are public in nature.