Azure Data Factory - Self Hosted IR as a proxy - Timeout when reading from staging.

Question

Hi,

We have been trying to run a SSIS package in ADF that fetches data from On-Prem sql server to Azure DB. We followed the Azure documentation and perform these steps :

1. Created a Self Hosted IR on an On-Prem VM.
2. Created a Azure-SSIS integration runtime and set the Self Hosted IR as a Proxy.
3. Created a linked service to Blob Storage(tried both via SHIR and AutoResolve IR) for Staging purposes.
4. We are using Windows credentials in the Execute SSIS Package task and ConnectByProxy is set to 1 for the Connection-Managers.

We are getting this error : "Azure Data Factory - Self Hosted IR as a proxy - Timeout when reading from staging" .

Note: Visual C++ is already installed on the VM and we can verify the SHIR connectivity to the On-Prem using other tasks .

Answer 1

Hello Aman Mehta IN010123681-MSP01,

Welcome to the MS Q&A platform.

From the error message, there is some issue with the staging path. Please check if the staging path exists and is set up correctly.

Also, please remove the staging path and see if it resolves it. If we remove the staging path, the default path is used.

I hope this helps.