SSIS包导入Excel文件到SQL Server

Question

我们拥有一批进口工作，以前工作的罚款。这些dtx软件包在安装了Office 2007的Windows XP盒子上从VS2005执行。

开发商还没有得到一个不错的新机，64位，Windows 7中，Office 2010的现在，当他试图执行他得到以下错误的包：

SSIS package "Import_BygningsKategorier.dtsx" starting. Information: 0x4004300A at Data Flow - Import_BygningsKategorier, DTS.Pipeline: Validation phase is beginning. Error: 0xC0202009 at Import_BygningsKategorier, Connection manager "Excel Connection Manager": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Error: 0xC020801C at Data Flow - Import_BygningsKategorier, Source - Import_BygningsKategorier [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Error: 0xC0047017 at Data Flow - Import_BygningsKategorier, DTS.Pipeline: component "Source - Import_BygningsKategorier" (1) failed validation and returned error code 0xC020801C. Error: 0xC004700C at Data Flow - Import_BygningsKategorier, DTS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Data Flow - Import_BygningsKategorier: There were errors during task validation. SSIS package "Import_BygningsKategorier.dtsx" finished: Failure. The program '[6332] Import_BygningsKategorier.dtsx: DTS' has exited with code 0 (0x0).

它看起来像问题可能是一个班级没有注册，我们如何找出哪些班级没有注册？

Answer 1

为Excel OLEDB驱动程序不存在64位。

运行DTS导入实用程序的32位版本（应该包含，看看在开始菜单）。