CODEWITHSUNDEEP
azuressisazure-data-factory
houba
houba

Reputation: 536

Why does SSIS on Prem require its own Azure SSIS IR (Proxy)?

I have a linked service from Azure data factory to onprem SQL server. The linked service is using a Self-Hosted IR. Why on earth do I need an Azure-SSIS Proxy to connect to the SSIS? What am I gaining?? Why can't it use the Self-Hosted IR?

The communication is working, but I just need to understand why.

THanks

Upvotes: 1

Views: 158

Answers (1)

ChunhuaGu-MSFT
ChunhuaGu-MSFT

Reputation: 61

If data movement uses Data Factory copy activity, it does not need Azure SSIS integration runtime. If data movement logic is inside SSIS package, and uses Execute SSIS package activity, it needs Azure SSIS integration runtime, and self-hosted IR as proxy.

Upvotes: 2

Related Questions