question

vishwanathanvasudevan-1230 avatar image
0 Votes"
vishwanathanvasudevan-1230 asked MartinJaffer-MSFT commented

ADF v2 SSIS IR CICD

HI Team, if you can guide me with below

Scenario:
Resource group A in east US.
ADF v2 with a Dual Standby SSIS IR.
SSISDB in Azure SQL Database. The SQL server is configured with a failover group, replicating SSISDB to a SQL Server in West US.
Azure DevOps Git Enabled.

Resource group B in West US.
ADFv2 created.
Secondary azure SQL database, part of failover group of SQL Server in East US.

Azure DevOps Integration:
An azure pipeline created to update the configuration in West US when East US ADF configuration are updated.
in Azure Pipeline in Overwrite parameter section, the Azure SQL database in West US is updated as the catalog database of IR.

Result:
1. A new pipeline created in ADF in east US gets updated in West US ADF.

Support required:
The SSIS IR created as part of the pipeline is in East US. Is there a way to overwrite the location of IR.

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@vishwanathanvasudevan-1230 are you still facing the issue? If you need more assistance, please tell me how I may better assist. If you already found a solution, please share it here. If my response resolved the issue, please mark as accepted answer.

0 Votes 0 ·

Hi Martin..Is there a way to update the location of SSIS IR when deploying the environment in another region using ARM templates from adf_publish. My solution is integrated with Azure DevOps. In overwrite parameters section of devOps pipeline i do not have an option to update the location of SSIS IR. I do have a SSISDB in failover group which copies the catalog to other region and can configure on the SSIS IR.

0 Votes 0 ·
vishwanathanvasudevan-1230 avatar image
0 Votes"
vishwanathanvasudevan-1230 answered MartinJaffer-MSFT commented

Hi Martin

The issue is resolved. The issue was fixed using the Custom parameter as mentioned in Link , the below syntax was added to update the location of IR In another region.

"typeProperties": {
"computeProperties": {
"location": "="
}



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for letting us know.

0 Votes 0 ·
MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered

Hello @vishwanathanvasudevan-1230 and welcome to Microsoft Q&A.

The region of existing Integration Runtimes cannot be changed, but you can choose the location of new ones during creation.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.