Azure Data factory self host IR

Question

Hi,

I am trying to load data from on premise to azure environment by lift and shift using self host IR.

I have created self hosted IR and used as a proxy in Azure-SSIS IR.

FYI I have created simple SSIS package with Dataflow task with Source( on premise DB) and Destination (azure sql db)

Problem is I am able to see that data get loaded into Azure environment.
But the Execute SSIS activity getting failed with the following error

"Data Flow Task:Error: The Execute method on the task returned error code 0x80131505 (Timeout when reading from staging). The Execute method must succeed, and indicate the result using an \"out\" parameter.\r\n\n",

Can anyone help me to solve this.

Answer 1

Hi @Jayasree Ramu ,

Welcome to Microsoft Q&A!

Firstly, please refer to this blog to check if you set the SSIS package correctly in the ADF Pipeline:

With Azure-SSIS IR, you can easily run the SSIS packages that are deployed into the SSIS catalog database, hosted in an Azure SQL Database server or an Azure SQL Database Managed Instance using the Project deployment model, or run the packages that are deployed into the file system, Azure Files, or SQL Server MSDB database that is hosted in an Azure SQL Database Managed Instance using the Package Deployment model.

Here has a similar thread, and poster solved the issue as following:

We were able to resolve this issue. We were referencing the Self Hosted IR in the connect via integration runtime dropdown. We went through the documentation again and changed it to Auto Resolve. This has resolved the error.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.