Skip to main content

Variables in SSIS


According to Microsoft, Variables store values that a SQL Server Integration Services package and its containers, tasks, and event handlers can use at runtime. The scripts in the Script task and the Script component can also use variables. The precedence constraints that sequence tasks and containers into a workflow can use variables when their constraint definitions include expressions.
Variable just like same as we use in our programming language but some differences in a variable declaration, we declare a variable in SSIS given bellow pic.
 

First, click on the menu SSIS and then click on Variables it open a variables windows given below.


To create a variable, click on the red pointed arrow. Here you can modify the variable name, data type, value, expression as per your requirement Same as if you want to remove/delete variable then click on the blue pointed arrow.

After click on green pointed arrow it's open a "Select New Scope" window from here you may decide your variable scope. see in below pic.