About #

Some of the values used in the component’s UI can be dynamically changed at SSIS package runtime, see Parameterization.
This section lists the component’s fields and custom properties that can be parameterized.

Custom Properties #

The Custom Properties define the properties unique to the Xtract Table component.
When parameterizing the Table component using SSIS variables or Data Flow Properties, the Custom Porperties are overwritten.

For a list of available Custom Properties, see Table Custom Properties.

Parameterization using Data Flow Properties #

The following properties can be parameterized:

Property Name Description
[Xtract Table].[WhereClause] Corresponds to the tab WHERE clause in the Table component. Allows parameterization of the complete WHERE clause, see Dynamization of WHERE conditions of the XIS table component.
[Xtract Table].[ConvertsDates] Enable or disable conversion of SAP dates, see Table Custom Properties.
[Xtract Table].[CustomFunctionName] Corresponds to the drop-down menu Function Module in the Table component’s Settings.
[Xtract Table].[MaxRows] Corresponds to the field Row Limit in the Table component’s Settings.
[Xtract Table].[MinDateReplacement] Converts the SAP date 00000000 to the entered value, see Table Custom Properties.
[Xtract Table].[MaxDateReplacement] Converts the SAP date 9999XXXX to the entered value, see Table Custom Properties.
[Xtract Table].[InvalidDateReplacement] Every invalid value will be converted into the entered value, see Table Custom Properties.
[Xtract Table].[PackageSize] Corresponds to the field Package Size in the Table component’s Settings.

Recommendation: Where possible, use properties for parameterization.

Parameterization using SSIS Variables #

The following fields and/or custom properties of the component allow entry of an SSIS variable:

Field Name Comment
WHERE clause tab Allows parameterization of the complete WHERE clause or only parts of the WHERE clause. For more information, see Using SSIS Variables in the WHERE Clause Editor or the knowledge base article Dynamization of WHERE conditions of the XIS table component.