SSIS错误之"The Excel Connection Manager is not supported in the 64-bit version of SSIS"

今天读了一下关于Sql Server 2008 Integration Service 的文章，就按照文章上的内容作个小练习，就是把数据库中的一个表导出到Excel 文件中，本来挺简单的问题，拖几下就能搞定，结果到了我那里，，，就是失败，，郁闷啊，错误信息如下： SSIS package "Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Error: 0xC00F9304 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. Error: 0xC020801C at Data Flow Task, Excel Destination [61]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "Excel Destination" (61) failed validation and returned error code 0xC020801C. Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Data Flow Task: There were errors during task validation. SSIS package "Package.dtsx" finished: Failure. The program '[3356] Package.dtsx: DTS' has exited with code 0 (0x0). 自己上网查了查，原来是因为我的操作系统是64 bit的，结果Sql Server 2008 在64 bit 机器上 对于Integration Service 关于Excel 导出的支持有问题，有价值的链接如下 http://msdn.microsoft.com/en-us/library/ms141766.aspx http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/289e29ad-26dc-4f90-bad4-ffb86c76e5f9 试了试谈到的方法， You can also set the 32 bit runtime environment using Project Properties -> Debugging -> Run64BitRuntime = False (in Visual Studio) 果真可以正确执行了