We have a SSIS package that uploads data to Blob storage. The package is used by multiple agent jobs with different parameters.
One job has recently started failing, we found that if we enabled Debug mode on the connection parameters for that one job, it started working again.
My initial thought was a timing issue, but the doesn't feel fully satisfying.
Any ideas why that should be?