Parameterization

Parameterization using SSIS Variables

SSIS variables store values that an SQL Server Integration Services package and its containers, tasks, and event handlers can use at runtime. The following settings in the Xtract BWLoader component allow entry of an SSIS variable:

• Package Size
• Gateway host
• Gateway service
• Program ID

Use SSIS Variables with @-Notation

To use SSIS variables in input fields of the component, place an @ symbol before the variable name.

1. Choose an input field that supports SSIS variables.
2. Instead of entering a fixed a value, enter a variable name using the @-notation, e.g., @vDate.
3. Create a new SSIS variable with the same name, but without the @ symbol, e.g., vDate.
4. Make sure to select the correct data type.

You can now use the SSIS variable to set dynamic input values for the input field.

Custom Properties of Xtract BWLoader

The Custom Properties are properties that are unique to the component. When parameterizing the component using SSIS variables, the Custom Properties are overwritten.

The Custom Properties of the Xtract BWLoader component are displayed in the "Properties" window.

List of relevant Custom Properties:

Related Links:

• Integration Services (SSIS) Variables