Custom Properties #
The Custom Properties define the properties unique to the component. When parameterizing the component using SSIS variables, the Custom Porperties are overwritten.
List of relevant Custom Properties:
Property | Comment |
---|---|
MaxRows | Corresponds to the field MaxRows in Settings of the Query component. |
QueryDescription | Description of the Query to be extracted. |
QueryName | Name of the Query to be extracted. |
StringConversion | Corresponds to the Settings of the Query component. |
UserGroup | Name of the User Group where the Query is located. |
Variant | Corresponds to the field Use Variant Variable in the Settings of the Query component. |
VariantDescription | Description of the Variant. |
Parameterizing Using SSIS Variables #
SSIS variables store values that an SQL Server Integration Services package and its containers, tasks, and event handlers can use at run time.
To use SSIS variables for parameterization of Xtract components, place an @-symbol before the variable name.
The following example shows how an SSIS variable named @vDate is used as a parameter in an Xtract component:
- Choose an input field that supports SSIS variables.
- Instead of entering a fixed a value, enter an SSIS variable using the @-notation.
- Open the SSIS variables window and add an SSIS variable with the same name, but without the @-symbol.
- Make sure to select the correct data type.
- Use the variable by entering values directly into the Value field or by assigning dynamic values in SSIS.
Available Parameters for SSIS Variables
List of input fields that allow entry of an SSIS variable:
Field Name | Comment |
---|---|
Variant | In the Xtract Query component, go to Settings and activate the check box Use Variant Variable. This allows using an SSIS variable for the field Variant. |