Random errors executing SSIS packages through Azure Data Factory

Miguel Buenestado 41

We are facing the following error throughout a big ADF pipeline in many SSIS packages execution tasks:

"Failed to retrieve resource from master. Microsoft.SqlServer.IntegrationServices.Scale.ScaleoutContract.Common.MasterResponseFailedException: Code:300004"

This error is said to be due to either file not accessible or password not valid.

In our case, this is does not apply. Those packages did not undergo any changes whatsoever and are accessible in a Azure Storage resource.

In fact, the same SSIS package may have always succeeded in the past (say, previous months executions) but failing now.

These are random errors we are getting which do not allow us to maintain an automated process. Sometimes some packages fail, other times they succeed and some other packages fail.

May you be able to help please?

Thanks in advance.

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2023-02-06T09:29:24.3766667+00:00

Hi Miguel Buenestado,

Are you using Execute SSIS Package activity in ADF here?

From the error message it seems there is a failure while trying to retrieve some resource from the master node. It can be because of project or package, or configuration is not accessible with credentials provided. Or may be some connectivity issues as well.

Could you please check if any network changes or permissions changes occurred behind the scenes and causing this issue?
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2023-02-15T11:55:34.9166667+00:00

Hi Miguel Buenestado, Just chekcking if any updates on above? Thank you.