Many of our servers run the 64-bit version of SQL Server and Integration Services and use components and /or providers that require 32-bit execution. Error: 0x C020801C at Load Excel File, Excel 2010 Destination : SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. Started: PM Error: 2013-10-01 .05 Code: 0x C0209303 Source: Package Connection manager “Excel Connection Manager” Description: The requested OLE DB provider Microsoft. The Acquire Connection method call to the connection manager “Excel Connection Manager” failed with error code 0x C0209303.There are several articles and blog / forum posts that address the problem with a couple of different methods depending upon what is needed but I haven’t stumbled upon a single source for all the methods put together in an easy to read way. The Acquire Connection method call to the connection manager “Excel Connection Manager” failed with error code 0x C00F9304. Error: 0x C0024107 at Load Excel File: There were errors during task validation. There may be error messages posted before this with more information on why the Acquire Connection method call failed. Error: 0x C00F9304 at Package, Connection manager “Excel Connection Manager”: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available. If the 64-bit driver is not installed, run the package in 32-bit mode. End Error Error: 2013-10-01 .05 Code: 0x C001002B Source: Package Connection manager “Excel Connection Manager” Description: The ‘Microsoft. OLEDB.12.0’ provider is not registered on the local machine. Link Id=219816 End Error Error: 2013-10-01 .05 Code: 0x C020801C Source: Load Excel File Excel 2010 Destination  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.There may be error messages posted before this with more information on why the Acquire Connection method call failed. Pipeline: component “Excel 2010 Destination” (19) failed validation and returned error code 0x C020801C. End Error Error: 2013-10-01 .05 Code: 0x C0047017 Source: Load Excel File SSIS.
It had been nagging me to upgrade for awhile and I finally gave in and did it.
End Error Error: 2013-10-01 .05 Code: 0x C0024107 Source: Load Excel File Description: There were errors during task validation. This means that often my servers will only have the database engine installed and possibly a few other features (such as Integration Services) as needed by the system.
End Error DTExec: The package execution returned DTSER_FAILURE (1). In most situations, there is no need for developer tools on a production server, therefore, BIDS and other components are omitted.
The wizard doesn’t treat identity columns any differently to other columns, so will usually fail when trying to insert data into a table that has an identity column.
However the error message can be a bit misleading : - Validating (Error) Messages • Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "System Information ID".