SSIS Package will stalls at Pre-Execution stage

Graham Rock 81 Reputation points
2023-11-14T10:41:48.3633333+00:00

Hello

I have developed a SSIS package that has been running fine for several years, until we move to Azure, now on one of the data flows the SSIS package stalls at Pre-Execution stage.

We used to have our Virtual Machine on servers in our office, a month ago we lift and shift our VM's to Azure and the package started to fail.

The SQL Server is 2016, it's a 32bit package.

The package has about 15 steps at the start it gets the date and clears the reporting database table down for the weeks data it is about to create. It then has data flows that query a third party MySQL database, and inserts and updates that data to the reporting table which is on the SQL Server of the VM.

The package runs 8 of the dataflows fine and gets to the largest one and just stalls at the pre-execution, the largest one is calculating all the sales for the year per product per shop. It will stop at 0% or get to 33% or 66% then stop. I have to kill the process.

The package runs fine on my machine in Visual Studio, which is my current work around, but it would be good to get this working on the servers automatically again.

I have tied a few setting like delay validation to true but nothing works.

Does anyone have any suggestions?

Regards

Graham.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,437 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 40,356 Reputation points
    2023-11-15T05:33:28.6833333+00:00

    Hi @Graham Rock,

    Have you tried to re-deploy the package?

    In addition, could you please enable the SSIS logging so that we could get more information.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.