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 ODP component.
When parameterizing the ODP component using SSIS variables or Data Flow Properties, the Custom Porperties are overwritten.

List of relevant Custom Properties of the ODP component:

Property Comment
ConvertsDates When this property is set to True (default) SAP date fields (YYYYMMDD) assume the SSIS pipeline type DT_DBDATE instead of DT_WSTR. In case of invalid data in SAP date fields, the following date conversions are applied:
InvalidDateReplacement, MaxDateReplacement, MinDateReplacement.
ExtractDataOnDeltaInit Runs a delta initialization with or without extracting data on init, see Update Mode.
HierarchyName Applies to Hierarchy DataSources only, see Select Hierarchy.
InvalidDateReplacement Allows the replacement of an invalid date format. The default value of the property 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 Allows replacing the SAP dates with the year 9999. The default value of the property 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 Allows replacing the SAP dates with the year 0000. The default value of the property 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 Sets the package size in bytes, see Advanced Settings.
SubscriptionSuffix Adds a suffix to the ODP subscription generated by the ODP component.
UpdateMode Allows setting the update mode of an extraction. Permitted values are: (F)ull, (D)elta and (R)ecovery, see Update Mode.

Parameterization using Data Flow Properties #

The following Custom Properties can be parameterized:

Property Name Description
[Xtract ODP].[SubscriptionSuffix] Adds a suffix to the ODP subscription generated by the ODP component. This allows using an SSIS package in two different SSIS environments, e.g. QA and PROD. accessing the same SAP system. The suffix allows generating a subscriber for each SSIS environment from the same ODP component.
[Xtract ODP].[UpdateMode] Allows setting the update mode of an extraction. Permitted values are: (F)ull, (D)elta and (R)ecovery, see Update Mode.
[Xtract.ODP].[ExtractDataOnDeltaInit] Runs a delta initialization with or without extracting data on init, see Update Mode.
[Xtract.ODP].[HierarchyName] Applies to Hierarchy DataSources only. Allows setting the name of the extracted hierarchy, see Select Hierarchy. Example: Loop over a list of hierarchies.
[Xtract.ODP].[PackageSize] Sets the package size in bytes, see Advanced Settings.
[Xtract.ODP].[ <Selection Parameter >] Selection parameters that are defined in the component are exposed as properties, see Edit Parameters.

Parameterization using SSIS Variables #

The following fields and/or Custom Properties of the component allow entry of an SSIS variable:

Field Name Comment
Edit Enter an SSIS variable as selection criteria, see Selections and Filters.
Package Size Sets the package size in bytes, see Advanced Settings.