CODEWITHSUNDEEP
azuressisazure-data-factory
Koen Vanden Bossche
Koen Vanden Bossche

Reputation: 56

Data Factory DevOps SSIS-IntegrationRuntime

We're planning to use CI/CD pipelines for Data Factory. In one of our pipelines we use SSIS packages that needs to be called. To call SSIS packages you need to specify an Azure-SSIS IR that must be used.

enter image description here

The Azure-SSIS IR has a different naming on every environment. Now, it is not possible to set this value dynamic (the option "Add dynamic content [Alt+P]" is not available on this field) Is there a simple solution to change the Azure-SSIS IR during the deployment?

Thanks in advance

Upvotes: 1

Views: 142

Answers (1)

Nick.Mc
Nick.Mc

Reputation: 19184

Your linked services aren't named by environment are they? (they most definitley should not be)

The default out of the box cloud runtime is also not named by environment.

Your runtimes should not be named by environment either.

IMHO your naming convention is incorrect. You should challenge it - there's no reason to include an environment designator in any runtime names.

Yes, your parent data factory should definitely have a different name per environment. That's where the distinction is made. Your runtimes should not.

In direct answer to your question, the way I have dealt with this in the past is added a powershell script task to the build part of DevOps that transforms the deployment asset and basically find/replaces the name the delivers the result as a build artifact

Upvotes: 1

Related Questions