Execution Parameterization

Any SSIS package that you upload on the COZYROC Cloud can be a template for multiple scheduled jobs, as it can be further parameterized. For example, if you need to use different connection strings for your staging and production environments, instead of having to upload two very similar versions of a package, you only need to parameterize a single package in two different ways.

What's parameterizable?#

Package Parameters#

Package parameters allow you to easily modify package execution without having to edit and redeploy the package. The parameters must be set up when the package is designed. Then, when the package is uploaded to the COZYROC Cloud, the parameters will show up under “Parameters” when the package is opened.

Connection Manager Properties#

All connection manager properties can be modified once a package has been uploaded to the COZYROC Cloud. The properties will initially have the values configured at design time. In addition, if no password is specified when the package is uploaded, then any sensitive information will need to be entered manually in the connection managers properties (either in the package or in the scheduled job(s))

Property Overrides#

Even if you haven't introduced a package parameter for easy customization of a particular property, you will still be able to modify any property value via a property override. You just need to specify the full path of the property.

How to parameterize values?#

There is a standard popup screen "Edit property" for parameterizing any property. There you can either specify a value directly or choose "use environment" and select a variable from the list of the environments linked to a job. See more info about enviroments.

NOTE: The TokenFile property of the COZYROC SSIS+ REST Connection Manager requires a custom setup (see here). A dropdown with a list of tokens appears when you paremeterize this property.