Excel Connection Manager - Moving between environments

Hi - I have an issue with the Excel Connection Manager when moving between environments (e.g. from DEV to TEST).

1. My Package contains an Excel Connection Manager X and an Excel Source Y

2. X has a hard-coded Excel File Path Value: C:\DEV\FinanceData.xls

X's DelayValidation property = True

Y's ValidateExternalMetaData = False

3. I have 2 Package Configurations:-

3.1 The first one is for "MachineResident" values, such as, drive e.g. D:

3.2 The second one is for "PackageSpecific" values, such as, feed file name

4. I set-up a Script Task to update X's ConnectionString using the values specified in my two package configurations. The ConnectionString is completely different to the hard-coded Excel File Path Value.

5. The Package works fine on my DEV machine

6. Then, I move it to TEST where the folder: C:\DEV\ does NOT exist ... and then when I run the package it fails immediately with:-

"The AcquireConnection method call to the connection manager "FeedFile Excel Connection Manager" failed with error code 0xC0202009."

It seems that the DelayValidation = True setting is not working with the Excel Connection Manager. Is this correct?

Thanks.

Why are you using a Script Task to set the connection string?