Skip to main content

Packages Overview

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 in the web app.

NOTE: For the shared managed execution environment (from the Standard plan), please see the recommendations below:

  • 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.
  • It's recommended to use the same version of COZYROC SSIS+ library for developing SSIS packages in Visual Studio, that matches the version used in COZYROC Cloud execution environment. Please also check 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, via the Dashboard page or using Visual Studio extension. 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.

Uploading new SSIS package version

If you updated your package in Visual Studio and you want to update it in COZYROC Cloud as well, you can do this by navigating to the package details page and clicking on Upload new version button as shown below.

img

You will be redirected to the usual package upload page with predefined readonly name and folder. Select your new package file, set password if necessary and click Save.

During the upload process parameters and connection managers from the new package will be compared to the currenly existing scheduled jobs and inbound webhooks parameters. If any of the following cases is detected for:

  1. Parameters
  • new parameter
  • missing parameter
  • parameter sensitivity changed
  • parameter data type changed
  1. Connection managers
  • new connection manager
  • missing connection manager
  • changed connection parameters in existing connection manager

Then you will be notified via email and you will be able to confirm or discard the changes from the package details page.

img

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.

img

Creating package webhook

You can create an inbound webhook and call it outside of COZYROC Cloud application via HTTP GET or HTTP POST request. When you call the webhook url it will trigger package execution.

img