Various settings of Xtract IS components (e.g., package size, selection criteria, etc.) can be parameterized. Use parameters to assign different values at SSIS package runtime. Parameters can be populated using standard SSIS functionality, such as expressions and SSIS variables.

Xtract IS offers two technical options for parameterization:

Recommendation: Microsoft’s preferred and recommended way of parameterization is using properties.

Depending on the Xtract IS component you can either use SSIS variables or Data Flow Properties or both to set parameters.

Parameterization Options in Xtract Components #

Component SSIS Variables Properties
BAPI x  
BW Cube x  
BW Hierarchy x  
BW Loader x  
DeltaQ x x
ODP x x
OHS x x
Query x  
Report x  
Table x x