I have created a SSIS job to transfer data from an Excel Spreadsheet to a SQL Server 2012 table.
When I run the package in Visual Studio, everything executes without a problem.
When I try running the job in SQL Server using SQL Agent, I get an error message to check the error Log. Nothing appears in the error log.
When I try running the job from a command prompt, I see the error as follows: "DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager DailyLogExcel" failed with error code 0xC0209303.
I have already set “Run64BitRuntime” property to false.