I have a for each loop container that obtains the data from a SQL database and outputs it in different Excel files based on the condition in the loop. Every time I run the package it randomly produces x amount of Excel files then fails with the error "Cannot Acquire Connection From Connection Manager" ie. sometimes it produces 10 excel files, sometimes 20, sometimes 30 but not the full amount. It clearly connects otherwise it wouldn't be producing some files, however during execution it will randomly fail with this error.
I have set the RunIn64BitMode property to False and set Delay Validation to True.
My version of Excel is 2010.
Any help is appreciated.