Azure Data Factory - Self Hosted Integration Runtime with SSIS package The Execute method must succeed, and indicate the result using an \"out\" parameter.\

Wojciech Bukowski 1 Reputation point
2021-04-20T10:19:27.983+00:00

I have SSIS Package that pulls data from On-premise data Source and push data to Azure Blob.
SSIS Package has been deployed to Azure SQL DB (SSISDB) and ADF Pipeline is created with this package.

On ADF Pipeline level I select Azure-SSIS IR (Self Hosted Integration Runtime that is using Virtual Machine inside Corporate Network)
Both: On Premise Data Source & Blob Destination has "ConnectByProxy" set to TRUE

Package Run Successfully on Visual Studio Debug

When I run (Debug) from ADF Pipeline:

  1. Package Pulls data successfully from On Premise Source
  2. Package push data successfully to Blob
  3. Steps 1 and 2 works super fast (10 sec)
  4. Now package hangs for around 10-11 minutes and returns 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\n4/19/2021 11:11:19 AM +00:00 : 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",

Last log entry from SH IR is:

LOAD Table to BLOB:Information: Cleanup phase is beginning.,,,OnInformation,LOAD Table to BLOB,{ID},SSIS.Pipeline,\Package\LOAD Table to BLOB,{ID}\LOAD LOAD Table to BLOB,9404,,,1074016265

I have also created another SSIS package that copy data inside of Machine that is used as Self-Hosted IR.
File is copied but package fails with same error.

Any suggestion how to fix / debug it further ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,857 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,305 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Kasa Vinod 1 Reputation point
    2021-12-16T19:37:26.7+00:00

    Not sure if this is safe option but after setting TSL to 1.0 from 1.2 the issue got resolved!

    158306-image.png

    No comments