Azure Data Factory (SSIS) Execution Using Integration Runtime Throws "Unexpected Termination"

0
votes

I have been using Azure Data Factory V2 for a while to execute SSIS packages from the SSISDB catalouges. Today (16-11-2018) I have encountered "Unexpected Termination" Failure message without any Warning and Error message.

Things than I have done:

  1. Executing the SSIS package manually from the SSISDB catalogue in SQL Server Management Services (SSMS). What i have noticed is that it took an exceptionally long time to assign the task to a machine. When the package is assigned to a machine, within 1 or two minutes it throws back the Failure message.
  2. There are 3 SSIS packages that is excecuted "sequentially" with the Azure Data Factory Pipeline. Often the 1st package is executed successfully, however the 2nd and 3rd package never succeded.
  3. Another error message that I got is "Failed pull task from SSISDB, please check if SSISDB has exceeded its limit".

I hope anyone can help me with this issue. I have been searching the web and could not find anything on this subject.

1
azuressisruntimeintegrationazure-data-factory-2

1 Answers

0
votes

What tier of Azure sql server have you provisioned for the SSISDB to run on? If its too small, it may be taking too much time starting and throw a timeout.

Personally, I've had no problems provisioning an S3 Azure Sql Server.

Hope this helped! Martin