Skip to content

Parameterization

This page shows how to parameterize the Xtract Report component using SSIS variables directly in the component and by using 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.

Note

The Xtract Report component does not support variables of the data types DateTime and DBNull. For more information on the data types of system variables, see Microsoft Documentation: System Variables.

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.

  1. Right-click the Data Flow canvas and select Properties. The window "Properties" opens.
  2. Add an Expression by clicking using […]. The window "Property Expression Editor" opens.
    Expressions
  3. Select a property from the drop-down list under Property.
  4. Open the "Expression Builder" using the […] button under Expression.
  5. Build your Expression and click [Evaluate Expression] to check for correct syntax.
  6. Confirm your input with [OK].

Data Flow Properties of Xtract Report

List of Data Flow Properties that can be parameterized:

Property Description
[Xtract Report].[Variant] Corresponds to the settings Variants in the {{ r }} component.
[Xtract Report].[BatchJobDestination] Corresponds to the setting Spool Destination in the Xtract Report component.
[Xtract Report].[BatchJobName] Corresponds to the setting Background Job Name in the Xtract Report component.
[Xtract Report].[BatchJobTimeout] Corresponds to the setting Background Job Timeout in the Xtract Report component.

Custom Properties of Xtract Report

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 Report component are displayed in the "Properties" window.

report-properties

List of the relevant Custom Properties:

Property Description
BatchJobDestination Corresponds to the setting Spool Destination in the Xtract Report component.
BatchJobName Corresponds to the setting Background Job Name in the Xtract Report component.
BatchJobTimeout Corresponds to the setting Background Job Timeout in the Xtract Report component.
DynamicColumnWidthsAndOffsets Corresponds to the setting Dynamic Column Widths and Offsets in the Xtract Report component.
ReportRowsPerDataRow Corresponds to the setting Report Rows Per Data Row in the Xtract Report component.
ReportWidth Corresponds to the setting Report Width in the Xtract Report component.
SkipBottomRows Corresponds to the setting Skip Rows from Bottom in the Xtract Report component.
SkipTopRows Corresponds to the setting Skip Rows from Top in the Xtract Report component.
UseBatch Corresponds to the setting Use Background Mode in the Xtract Report component.
Variant Corresponds to the setting Variant in the Xtract Report component.
Last update: July 7, 2024