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?