SSIS Imp Fastload Rows Per Batch
Overview
SSIS Imp Fastload Rows Per Batch is an SSIS Packages parameter that controls the rows-per-batch setting used during fast load in the generated SSIS import package.
Function
Use this setting to keep generated SSIS package execution consistent across the project. AnalyticsCreator uses this value when no custom value is saved for the project.
Access
The parameter is maintained from the Parameters list in AnalyticsCreator.
How to access
Navigation tree
Parameters->List Parameters
Toolbar
Options->Parameter
Diagram
Not opened from the diagram.
Visual element
Parameter list
Default value
10000
Custom value
Not set.
Where it is used
This parameter belongs to the SSIS Packages group and is used when AnalyticsCreator applies generated SSIS package execution.
| Setting | Value |
|---|---|
| Technical parameter name | SSIS_IMP_FASTLOAD_ROWSPERBATCH |
| Default value | 10000 |
| Custom value | Not set. |
Parameter groups
| Group |
|---|
| SSIS Packages |
| SSIS Runtime |
| SSIS |
