The SSIS Package Fails saying
"The AcquireConnection method call to the connection manager "Excel_Source" failed with error code 0xC0202009"
Here is how the Package is Ran:
1. Package has triggered as part of SQL Server Job.
2. SQL Server Job Ran based on proxy, an user will be able to Access only if he access to the proxy.
3. SQL Server has been set to Run on 32 Bit Run Time.
4. When the Excel file size is less than or equal to 2MB, File gets loaded with no issues.
In my local machine the %TMP% is free and C Drive has good Space update 2 GB.
Please need help to understand where the issue is.