Custom Properties #

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

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

Parameterizing Using Expression Properties #

The recommended way of parameterization is to use SSIS expressions to set Data Flow Properties.
Data Flow Properties are displayed in the “Properties” window of the Data Flow Task. These properties are not to be confused with Custom Properties that are displayed in the “Properties” window of the component. When parameterizing the Data Flow Properties, the Custom Porperties are overwritten.

For more information on property expessions, see Microsoft Documentation: Use Property Expressions in Packages.

How to Use Expressions for Data Flow Properties

  1. Create an SSIS package, see Getting Started.
  2. Right-click the Data Flow canvas and select Properties. The window “Properties” opens.
  3. Add an Expression by clicking using […]. The window “Property Expression Editor” opens.
    Expressions
  4. Select a property from the drop-down list under Property.
  5. Open the “Expression Builder” using the […] button under Expression.
  6. Build your Expression and click [Evaluate Expression] to check for correct syntax.
  7. Confirm your input with [OK].

Available Data Flow Properties

List of Data Flow Properties that 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.

Parameterization using SSIS Variables #

List of input fields that 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.