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:

  1. Choose an input field that supports SSIS variables.
  2. Instead of entering a fixed a value, enter an SSIS variable using the @-notation.
  3. Open the SSIS variables window and add an SSIS variable with the same name, but without the @-symbol.
  4. Make sure to select the correct data type.
  5. 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.