Hi everyone,
For several weeks now we have issues with an SSIS package connected to an Azure SQL server which sometimes (at least every few days) hangs in the Validation phase of an Excel source task which reads an Excel file from a shared network drive, or lately, also failed with error in the Prepare for Execute phase (no error event even triggered, so I only notice this when checking logs).
The error never seems to happen when the package is run manually from SSMS, only when it's scheduled to run at night.
I tried rebuilding the dataflow task, changing to different versions of the Micrsoft Excel version (driver), but the error keeps appearing from time to time.
Has anyone had any simular issues? Or maybe some ideas how to troubleshoot the issue as there is really nothing to go on now.
Thanks