使用SSIS 2012将数据从Sql Server 2014导出到Excel文件

鲁艾哈迈德

我正在使用Windows 8.1，Office 2013，Visual Studio 2013，SQL Server 2014和SSIS 12.0

我有一个包含OLE DB源，数据转换和Excel目标的数据流。我的OLEDB源
数据转换我已经在（C：\ XX）文件夹中创建了一个Excel文件StudentInfo.xls并建立了连接

一切都很好，但是当我执行它时，出现以下错误：

Error: 0xC0209303 at DynamicExcel, Connection manager "Excel Connection Manager": The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

Error: 0xC020801C at Data Flow Task, Excel Destination [24]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

This link (Switch package from 64bit to 32bit) led me to change the Run64BitRuntime property to False.

After changing the property, I am now getting a different set of errors:

Error: 0xC0202009 at DynamicExcel, Connection manager "Excel Connection Manager": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.".

Error: 0xC020801C at Data Flow Task, Excel Destination [24]: 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.

Suvethan Nantha

I've the same message, I have an SSIS project on visual studio 2010, I read a file.xls on that page, in my project VS 2010 has not any problem when I tried to store some query results to excel file, throw me a 'Microsoft.Jet.OLEDB.4.0' the provider is not registered on the local machine', I fixed that problem next following this steps,

1.-Open IIS

2.-Change the appPool on Advanced Settings

3.-true to enable to 32-bit application.

就这样

ps.I在Active Solution Platform上将Configuration Manager更改为X86

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。