Execution Parameterization
Any SSIS package you upload on the COZYROC Cloud can be a template for multiple scheduled jobs or inbound webhooks, as it can be further parameterized. For example, suppose you need to use different connection strings for your staging and production environments. Instead of uploading two very similar versions of a package, you only need to parameterize a 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.
Parameter predefined values
You can configure a list of allowed values for a package parameter for Numeric
and String
parameters. To achieve that you have to go to package details and pick a parameter to edit.
Then you click on Settings
tab and check Add predefined values
checkbox. Add wanted values and click Apply
.
In case you have added parameter predefined values then your parameter value must be one of these values.
Hence, when you create or update a scheduled job
or inbound webhook
you will be allowed to select a parameter value only from the predefined list.
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 (in the package, in the scheduled job(s) or in the inbound webhook(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 environments.
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 parameterize this property.