The report path is the full path to the drive and folder the excel sits in.

and the ActiveWaiters is AWLS which the foreach loop applies

There are no other errors.

That's the bit I'm falling down on.

I have set my expressions as follows

ExcelFilePath = @[User::ReportPath]

Name =...

This is the error I'm getting now.

[Excel Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "\\myhsfp02b\data$\RTT_Validation_Team\DQ Exception Reports\Exceptions\Automated Exception Reports\Active Waiters Unable...

No I hadn't but there is still an issue as it can not connect. I have set the Retain Same Connection to true. It's can't find the excel.

No real errors it just wont connect and when I run's it it comes back with VS_ISBROKEN which I know is incorrect because the package works if I point it...