SSIS Packages
Controls generated SSIS package buffering, fast-load, and execution behavior.
Use this page to find the SSIS Packages settings, review their defaults, and open the detailed parameter pages.
Available parameters
| Parameter | Technical name | Default value | Purpose |
|---|---|---|---|
| SSIS Command Timeout | SSIS_COMMAND_TIMEOUT | Not set. | SSIS CommandTimeout property. Will not be set if empty. |
| SSIS Delay Connection Validation | SSIS_DELAY_CONNECTION_VALIDATION | 0 | Delay SSIS connection validation. 0 - No, 1 - Yes. |
| SSIS Export Bulk Insert | SSIS_EXPORT_BULK_INSERT | 1 | SSIS Parameter for export package. |
| SSIS Export Default Buffer Max Rows | SSIS_EXPORT_DEFAULTBUFFERMAXROWS | 10000 | SSIS Parameter for export package. |
| SSIS Export Default Buffer Size | SSIS_EXPORT_DEFAULTBUFFERSIZE | 10485760 | SSIS Parameter for export package. |
| SSIS Export Fastload Check Constraints | SSIS_EXPORT_FASTLOAD_CHECKCONSTRAINTS | 0 | SSIS Parameter for export package. |
| SSIS Export Fastload Keep Identity | SSIS_EXPORT_FASTLOAD_KEEPIDENTITY | 0 | SSIS Parameter for export package. |
| SSIS Export Fastload Keep Nulls | SSIS_EXPORT_FASTLOAD_KEEPNULLS | 0 | SSIS Parameter for export package. |
| SSIS Export Fastload Max Insert Commit Size | SSIS_EXPORT_FASTLOAD_MAXINSERTCOMMITSIZE | 50000 | SSIS Parameter for export package. |
| SSIS Export Fastload Rows Per Batch | SSIS_EXPORT_FASTLOAD_ROWSPERBATCH | 10000 | SSIS Parameter for export package. |
| SSIS Export Fastload Table Lock | SSIS_EXPORT_FASTLOAD_TABLELOCK | 1 | SSIS Parameter for export package. |
| SSIS Hist Default Buffer Max Rows | SSIS_HIST_DEFAULTBUFFERMAXROWS | 10000 | SSIS Parameter for historization package. |
| SSIS Hist Default Buffer Size | SSIS_HIST_DEFAULTBUFFERSIZE | 10485760 | SSIS Parameter for historization package. |
| SSIS Hist Fastload Check Constraints | SSIS_HIST_FASTLOAD_CHECKCONSTRAINTS | 1 | SSIS Parameter for historization package. |
| SSIS Hist Fastload Keep Identity | SSIS_HIST_FASTLOAD_KEEPIDENTITY | 0 | SSIS Parameter for historization package. |
| SSIS Hist Fastload Keep Nulls | SSIS_HIST_FASTLOAD_KEEPNULLS | 0 | SSIS Parameter for historization package. |
| SSIS Hist Fastload Max Insert Commit Size | SSIS_HIST_FASTLOAD_MAXINSERTCOMMITSIZE | 50000 | SSIS Parameter for historization package. |
| SSIS Hist Fastload Rows Per Batch | SSIS_HIST_FASTLOAD_ROWSPERBATCH | 10000 | SSIS Parameter for historization package. |
| SSIS Hist Fastload Table Lock | SSIS_HIST_FASTLOAD_TABLELOCK | 1 | SSIS Parameter for historization package. |
| SSIS Imp Default Buffer Max Rows | SSIS_IMP_DEFAULTBUFFERMAXROWS | 10000 | SSIS Parameter for import package. |
| SSIS Imp Default Buffer Size | SSIS_IMP_DEFAULTBUFFERSIZE | 10485760 | SSIS Parameter for import package. |
| SSIS Imp Fastload Check Constraints | SSIS_IMP_FASTLOAD_CHECKCONSTRAINTS | 0 | SSIS Parameter for import package. |
| SSIS Imp Fastload Keep Identity | SSIS_IMP_FASTLOAD_KEEPIDENTITY | 0 | SSIS Parameter for import package. |
| SSIS Imp Fastload Keep Nulls | SSIS_IMP_FASTLOAD_KEEPNULLS | 0 | SSIS Parameter for import package. |
| SSIS Imp Fastload Max Insert Commit Size | SSIS_IMP_FASTLOAD_MAXINSERTCOMMITSIZE | 50000 | SSIS Parameter for import package. |
| SSIS Imp Fastload Rows Per Batch | SSIS_IMP_FASTLOAD_ROWSPERBATCH | 10000 | SSIS Parameter for import package. |
| SSIS Imp Fastload Table Lock | SSIS_IMP_FASTLOAD_TABLELOCK | 1 | SSIS Parameter for import package. |
| SSIS Not Store Connection Strings In Package | SSIS_NOT_STORE_CONNECTION_STRINGS_IN_PACKAGE | 0 | Do not store connection strings in the SSIS package. 0 - store, 1 - not store. |
| SSIS Replace Decimal Separator | SSIS_REPLACE_DECIMAL_SEPARATOR | 1 | 0 - do not replace, 1 - replace point by comma, 2 - replace comma by point. |
