Database Reference
In-Depth Information
in these implementations, it's important to understand how best to address SSIS vari-
ables within the scripting tools.
Note It is important to draw a distinction between variables in SSIS and variables
declared within the Script task and Script component. Although there's some common-
ality in their usage, they are separate and distinct entities with very different properties.
SSIS variables are defined as part of the SSIS package and may be used across many
different tasks and components. Script variables, on the other hand, are declared within
individual instances of the Script task or Script component and are only valid within the
instance in which they are defined.
Variable Visibility
In both the Script task and Script component, you can explicitly expose one or more
variables using the GUI editor for each. In Figure 3-9 , you can see that we have the op-
tion of including SSIS variables in the script and can specify whether those variables
will be surfaced as read-only or read-write.
Figure 3-9 . Including variables in script
It is possible to read or modify SSIS variables with a script even if you don't expli-
citly include them. However, it's usually preferable to declare any required variables as
shown, since the syntax within the script is much simpler when references to the SSIS
variables are declared ahead of time in this manner.
 
 
Search WWH ::




Custom Search