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
DateTo The default value of Date To is 99991231.
FetchText Corresponds to the field Fetch description texts in Settings - Extraction Settings.
HierarchyID ID of the Hierarchy to be extracted.
HierarchyName Name of the Hierarchy to be extracted.
HierarchyVersion Version of the Hierarchy to be extracted.
InfoObject Corresponds to the field InfoObject in Defining a BW Hierarchy.
StringConversion See Settings - String Conversion.

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 für SSIS Variablen

List of input fields that allow entry of an SSIS variable:

Field Name Comment
HierarchyName An SSIS variable can be entered in the component’s custom properties. In combination with a for-each-loop container, this allows extracting multiple hierarchies of the same InfoObject.
HierarchyVersion An SSIS variable can be entered in the component’s custom properties. In combination with a for-each-loop container, this allows extracting multiple hierarchy versions of the same hierarchy.