ERROR: 0XC00F9304 THE EXCEL CONNECTION MANAGER DOES NOT SUPPORT IN THE 64-BIT VERSION OF SSIS

Scenario - My SSIS solution was working fine until I did not try with an excel file as source.
I found the error with the error code 0XC00F9304 during package run.

Reason - This problem is coming because the excel connection manager does not support in the 64-bit version of SSIS.

Solution -  In order to resolve this problem, It is required to set Run64BitRuntime property to false.
Follow the below steps to change this property -

Step 1 - Select SSIS solution and click on Debugging tab under Configuration properties.

Step 2 - Set Run64BitRuntime property to false under debug options.

(Find the below screen shot for your reference)

I hope this will help.