Custom Properties #

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

List of relevant Custom Properties:

Property Comment
DataSourceType Corresponds to the field Data Source in the BW Loader component, see Connect Source and Destination Columns.
GatewayHost Corresponds to the field Gateway host in the BW Loader component, see Connect Source and Destination Columns.
GatewayService Corresponds to the field Gateway service in the BW Loader component, see Connect Source and Destination Columns.
InfoPackage Corresponds to the field InfoPackage in the BW Loader component, see Defining a BW Loader Extraction.
InfoSource Corresponds to the field InfoSource in the BW Loader component, see Defining a BW Loader Extraction.
LogSys Corresponds to the field Logical System in the BW Loader component, see Connect Source and Destination Columns.
NolPackageStartOnlyWait Corresponds to the field No InfoPackage Start (Only Wait) in the BW Loader component, see Settings.
PackageSize Corresponds to the field Package Size in the BW Loader component, see Settings.
ProcessChain Corresponds to the field Trigger Process Chain after Upload in the BW Loader component, see Settings.
ProgramID Corresponds to the field Program ID in the BW Loader component, see Connect Source and Destination Columns.
WaitUntilFinished Corresponds to the field Wait data transfer to be finished in the BW Loader component, see Settings.

Parameterizing Using SSIS Variables #

SSIS variables store values that an SQL Server Integration Services package and its containers, tasks, and event handlers can use at run time.
To use SSIS variables for parameterization of Xtract components, place an @-symbol before the variable name.

The following example shows how an SSIS variable named @vDate is used as a parameter in an Xtract component:

  1. Choose an input field that supports SSIS variables.
  2. Instead of entering a fixed a value, enter an SSIS variable using the @-notation.
  3. Open the SSIS variables window and add an SSIS variable with the same name, but without the @-symbol.
  4. Make sure to select the correct data type.
  5. Use the variable by entering values directly into the Value field or by assigning dynamic values in SSIS.

Available Parameters for SSIS Variables

List of input fields that allow entry of an SSIS variable:

Field Name Comment
Package Size Sets the package size in bytes, see Settings.
Gateway host Corresponds to the field Gateway host in the BW Loader component, see Connect Source and Destination Columns.
Gateway service Corresponds to the field Gateway service in the BW Loader component, see Connect Source and Destination Columns.
Program ID Corresponds to the field Program ID in the BW Loader component, see Connect Source and Destination Columns.