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 Report component.
When parameterizing the Report component using SSIS variables, the Custom Porperties are overwritten.

List of relevant Custom Properties of the Report component:

Property Comment
BatchJobDestination Corresponds to the field Spool Destination in the Report component, see Settings - Spool Destination / BatchJobDestination.
BatchJobName Corresponds to the field Batch Job Name in the Report component, see Settings -BatchJobName.
BatchJobTimeout Corresponds to the field Batch Timeout in the Report component, see Settings - BatchJobTimeout.
ReportName Name of the report that is to be extracted.
ReportRowsPerDataRow Corresponds to the field Report Rows Per Data Row in the Report component, see Defining Report Columns.
ReportWidth Corresponds to the field Report Width in the Report component, see Defining Report Columns.
SkipBottomRows Corresponds to the field Skip Rows Bottom in the Report component, see Defining Report Columns.
SkipTopRows Corresponds to the field Skip Rows Top in the Report component, see Defining Report Columns.
StringConversion See Settings - String Conversion.
UseBatch Corresponds to the field Use Batch in the Report component, see Settings - Use Batch.
Variant See Variants and Selections.

Parameterization using SSIS Variables #

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

Field Name Comment
Variant See Variants and Selections.
Edit Enter an SSIS variable as selection criteria, see Variants and Selections.
Spool Destination / BatchJobDestination Corresponds to the field Spool Destination in the Report component, see Settings - Spool Destination / BatchJobDestination.
BatchJobName Corresponds to the field Batch Job Name in the Report component, see Settings -BatchJobName.
BatchJobTimeout Corresponds to the field Batch Timeout in the Report component, see Settings - BatchJobTimeout.
ReportName Should not be used as the structure of the result as it varies depending on the reports.