Skip to content

Parameterization

This page shows how to parameterize the Xtract ODP(OData) component using SSIS variables and SSIS expressions to set Data Flow Properties.

Parameterization using SSIS Variables

SSIS variables store values that an SQL Server Integration Services package and its containers, tasks, and event handlers can use at runtime.

You can use SSIS variables for selections. Available SSIS variables are listed in the selection settings when parameter input ( ) is selected, see Edit Selections.

Custom Properties of Xtract ODP

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

The Custom Properties of the Xtract ODP(OData) component are displayed in the "Properties" window.

odp-properties

ConvertsDates

When this property is set to True (default) SAP date fields (YYYYMMDD) assume the SSIS pipeline type DT_DBDATE instead of DT_WSTR. For the date conversions to apply, set the property UseLegacyDateConversion to False. In case of invalid data in SAP date fields, the following date conversions are applied:

  • InvalidDateReplacement
  • MaxDateReplacement
  • MinDateReplacement

InvalidDateReplacement

Replaces an invalid date format. The default value is 1970-01-02. To use the property enter a replacement value for invalid SAP dates, such as '20190132' (January 32nd 2019) in the format yyyy-mm-dd. The value NULL is supported.

MaxDateReplacement

Replaces SAP dates with the year 9999. The default value is 2099-12-31. To use the property enter a replacement value in the format yyyy-mm-dd that contains the year ‘9999’. Example: ‘99990101’ (January 1st 9999). The value NULL is supported.

MinDateReplacement

Replaces SAP dates with the year 0000. The default value is 1970-01-01. To use the property enter a replacement value in the format yyyy-mm-dd that contains the year '0000'. Example: '00000000'. The value NULL is supported.

PackageSize

Corresponds to the setting Package Size.

Track Changes

Corresponds to the setting Delta / Change tracking that initializes delta extractions. For more information, see Subscriptions.

Last update: August 1, 2025