Generate SSIS Packages (kourier_export_sql_batch.aspx)

Purpose

To Generate multiple SSIS packages for one or more selected SQL Export Specifications in one batch. To create the SSIS Packages you must select the export specifications to process and then click the Generate Packages button from the tool bar. You will be asked to enter a number of parameters before the SSIS package can be generated. See the Generate Packages command below for more information.

Available Toolbar Commands

Click the Generate Packages icon in the toolbar to generate an SSIS package for each SQL Export Specification that has been selected.

After clicking this button a new Batch Package Configuration for SQL Export window will open. Enter the required package configuration parameters and click the Generate button. For more information on package configuration see the Generate SSIS Package process. The window will close and a new progress window will open to display the processing status and any errors encountered while generating each SSIS package.

Note: The parameters entered in the Batch Package Configuration for SQL Export will apply to all selected SQL Exports. If you want more control over the package configuration parameters for each SSIS package, use the SQL Export Specification page to build each package separately.
Click the Help balloon to open the help for this page.

Other Commands

Click the Select All button to select all SQL Export Specifications on the page that are valid for generating SSIS packages. Note, depending on the current status of each export specification, not all items will be selected.
Click the Deselect All button to deselect all SQL Export Specifications on the page.
The Integration filter, defaults to (All). Select an integration from the list provided to display only the SQL Export Specifications that belong to that integration.
The Export Data File filter, defaults to (All). Select a export data file from the list provided to display only the SQL Export Specifications that are associated to that data file.

File/Key Field

KT_EXPORTS/Export Name

Prerequisites

All SQL Export Specifications should have been designed and tested to ensure they export the correct data and produce the desired results.

Cautions

Existing SSIS packages for the selected SQL Export Specifications will be overwritten with new packages.

Fields

Field Name Description - Usage - Notes

Select checkbox. This is used to indicate which SQL Export Specifications you want to want to include in the batch SSIS package generation process.
Name The export specification name.  By convention, exports are named using an Integration ID such as KS for KommerceServer, followed by an underscore and a string that describes its purpose (e.g., KS_CONTACTS).

Click the name to open the SQL Export Specification. You can then edit or review all of the information for that export.
Export Data Files Displays the name of the data file used to export data records. If there are multiple export files (i.e., related files) only the primary export data file is displayed followed by a number in square brackets indicating how many total export data files are entered on the export specification. For example, if the primary export data file is GL, and there are two additional related GL files, the field will display as "GL [3]".
Last Update This displays the last date/time that the export specification was saved.
Last Package Generation Displays the last date/time that the SSIS package was successfully generated for this export specification.

User Guide - Table of Contents