Database Reference
In-Depth Information
An SSIS variable can be used to temporarily hold results or configuration data in random-access memory
(RAM). Variables can be added to your package by using the Variables window. This window does not normally
appear in a new package but can be opened using the Variables submenu item found in the SSIS menu, as shown
in Figure
7-20
.
Figure 7-20.
Displaying the SSIS Variables window
■
The ssis menu options change depending on the element of the Ui you have as your current focus. if you
do not see the Variables menu item, try clicking the Control Flow designer surface and look under the ssis menu
once more.
Note
SSIS has many premade variables available, but when you first open the Variables window, you will not see
them. And although we do not use them in this chapter, you can display the premade system variables by clicking
the fourth button on the Variables window's toolbar, circled in Figure
7-21
, and checking the “Show system
variables” checkbox.
Additional variables can be added by clicking the first button on the Variables window toolbar. The other
buttons on the toolbar control features such as deleting a variable or moving variables between scopes.
