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.
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
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:
- new parameter
- missing parameter
- parameter sensitivity changed
- parameter data type changed
- 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
discard the changes from the package details page.
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.
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.