Parameterization
This page shows how to parameterize the Xtract 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.
Parameterization 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.
Note
Data Flow 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 Properties are overwritten.
For more information on property expressions, see Microsoft Documentation: Use Property Expressions in Packages.
- Right-click the Data Flow canvas and select Properties. The window "Properties" opens.
- Add an Expression by clicking using […]. The window "Property Expression Editor" opens.
- Select a property from the drop-down list under Property.
- Open the "Expression Builder" using the […] button under Expression.
- Build your Expression and click [Evaluate Expression] to check for correct syntax.
- Confirm your input with [OK].
Data Flow Properties of Xtract OData
List of Data Flow Properties that can be parameterized:
| Property | Description |
|---|---|
| [Xtract.ODATA].[PackageSize] | Corresponds to the setting Package Size. |
| [Xtract.ODATA].[RowsLimit] | Corresponds to the setting Row Limit. |
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 OData component are displayed in the "Properties" window.
RowsLimit
Corresponds to the setting Row Limit.
PackageSize
Corresponds to the setting Package Size.
Related Links
- Microsoft Documentation: Integration Services (SSIS) Variables
- Microsoft Documentation: Use Property Expressions in Packages