SSIS Variable use issue in Data Flow

Question

At the beginning of the project I created 3 variables with Scope size Package:

I then created a SQL EXECUTE TASK:

Checking this query on SQL SERVER returns:

Setting EXCEL source as the variable which will get the file location:

Now on SSIS, I checked both ways 64bit debugging as true and as false. But rest of execution works when it is false, therefore I changed it back to false and saved it.

This is the Flow of project:

Whenever I Execute, it gives me this error:

How to resolve this error. It has taken my whole day but i am still clueless about it. I am new to SSIS. Help will be appreciated.

---

Edited:

Please see the result set of SQL EXECUTE TASK:

Answer 1

I noticed that the DelayValidation is False in your Excel Connection String.

You have to make DelayValidation=TRUE for both Excel Connection String and the Data Flow Task within which the excel connection is used.

Hope this would help you out.

Answer 2

After alot of struggle i've resolved the issue, but i am really thankful to the people who have given me some extra knowledge about this Tool and some of their guidance must have worked as well at some point as i have set my things accordingly.

what i did at last, which made it work and running were:

1) In package property, under Execution set DelayValidation to True. After following:

(Above, Viki helped me also by setting property DelayValidation to True, but in Excel Connection Manager which counts.)