SSIS Packages

SSIS packages encode the functionality for an integration scenario by using reusable and customizable building blocks - SSIS Connection managers, Control Flow elements, Data Flow elements, etc.

Developing SSIS packages#

SSIS packages are developed in Visual Studio, where they can be locally tested. When they are ready to be deployed, they can be uploaded to the COZYROC Cloud.

  • It's recommended that the target for your packages be set to SQL Server 2019, as the execution engine uses SQL Server 2019. The automatic upgrade of SSIS packages is not guaranteed to always work properly.
  • It's recommended to use either Visual Studio 2019 or Visual Studio 2017, both of which support SQL Server 2019 as a target.
  • We currently recommend version 2.0.100.1961 of the COZYROC SSIS+ library for developing SSIS packages in Visual Studio. Also, see the COZYROC SSIS+ to SSDT compatibility matrix for other compatibility considerations.

Uploading SSIS packages#

You can reach the page for uploading a package via Packages > Upload Package or via the Dashboard page. There, you'll need to select the package for upload and, optionally, specify a folder name. If the sensitive data in the package is password protected, it is recommended that you specify the password when uploading the package; otherwise, you'll need to manually input all the sensitive values later.

Scheduling SSIS package executions#

After uploading a package, you can create a scheduled job to run it on a regular basis. You might need to parameterize the execution first. We recommend that you do a test run and inspect the logs before scheduling executions.