SQL Server Integration Services

Data Governor Online supports SSIS and is an available task type that is more user friendly when using your existing SSIS.

Connecting to SSIS

When connecting to SSIS task types use a standard SQL Server Connection that must point at the SSISDB.

SSISDB.gif

To get started using SSIS in Data Governor Online, you will need to create a SQL Server connection which points at the SSISDB database.

Data Governor Online only supports the Project Deployment model for SSIS packages. Read more detail here.

Adding a SSIS Package Task

Adding a SSIS package is like any other task in Data Governor Online, where you can use the package selector to easily find available packages to run.

You then need to provide the package path that can be selected from the dropdown menu. Once you click Select the SSIS Package’s path will display below.

Select SSIS Package

You can then add any additional parameters.

Additional Parameters

Data Governor online supports all SSIS parameter types.

Once submitted you can run the task and view its execution logs.

Viewing SSIS Logs

Click run and it will then showcase the SSIS logs. The logs will appear in the execution logs for a job and will be easy to identify as all SSIS logs will be prefixed with [SSIS].

Execution Log

If an error occurs in SSIS it will also result in an error in Data Governor Online and show in the execution logs.