Defining an SSIS Package job

This procedure describes how to define an SSIS Package job.

The SSIS feature in Control-M for Databases has the following requirements:

• SSIS Packages are executed only on a Windows computer.
• SSIS Packages are executed locally on the computer where the Control-M/Agent is installed.
• SSIS service installed on the Control-M/Agent computer.

  NOTE: If you are accessing more than one version of SSIS with a specific Windows Control-M/Agent make sure that only 1 and the Latest version of the MSSQL Client (Integration Services) is installed on this Windows box.

Before you begin

Ensure that you have met the following requirements:

• A configured database connection profile, as described in Connection profile management.
• Successful completion of Accessing the Database job properties pane.

To define an SSIS Package job:

1. In the General tab, from the Connection Profile field, click .

   The Select Connection Profile dialog box appears.

2. Select the connection profile that you want to use and click OK.
3. From the Execution Type drop-down list, select SSIS Package.
4. From the Package Source drop-down list, select one of the following:
   • SQL Server: Package stored on an MSSQL database
   • File System: Package stored on the Control-M/Agent's local file system
   • SSIS Package Store: Package stored on a file system that is managed by an SSIS service.
   • SSIS Catalog: Package stored on a file system that is managed by an SSIS Catalog service.
5. In the Package Name field, click , browse to the location, and select the SSIS Package.

   If you select the SSIS Catalog option, the Catalog Environments field appears. If you want to run the package on a different environment than the one you are currently using, from the Environment field, click and select the environment you want to run the SSIS catalog on, and continue to step 8.

6. If you want to apply specific data that is saved in a configuration file to the SSIS Package, in the Configuration Files area, click .
7. Browse and select the configuration file that you want to add.
8. If there are property paths in this package, in the Properties table, click and type the property path and its value.
9. Click More Options.
10. To automatically commit queries, select the Auto Commit checkbox.
11. In the Job Output option area, select one or more of the following:
    • Append execution log to Job Output: Shows the Environment information, Request statement, and Job statistics in the Output.
    • Append SQL output to Job Output: Shows the job output in a Text, XML, CSV, or HTML format.

      From the Output format drop-down list, select an output format.

      If you select CSV output format, define a CSV separator in the CSV Separator field. The CSV separator enables you to separate your output data with specific delimiter characters.

    For more information about defining a job in the job properties pane, see Control-M Workload Automation User Guide.