将数据导出到Excel文件从Sql Server 2014使用SSIS 2012 [英] Exporting Data to Excel file From Sql Server 2014 using SSIS 2012
问题描述
我有一个数据流，它具有OLE DB源，数据转换和Excel目的地。
我的OLEDB来源
数据转换
我已经在（C：\XX）文件夹中创建一个Excel文件StudentInfo.xls并进行连接
一切都可以，但是当我执行它时，我给我以下错误：
错误：0xC0209303在DynamicExcel，Connection经理Excel连接管理器：请求的OLE DB提供程序
Microsoft.Jet.OLEDB.4.0未注册。如果64位驱动程序未安装
，请以32位模式运行程序包。错误代码：0x00000000。
可以使用OLE DB记录。资料来源：Microsoft OLE DB服务组件Hresult：0x80040154说明：类未注册。
错误：0xC020801C在数据流任务，Excel目的地[24]：SSIS错误代码DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER。
AcquireConnection方法调用连接管理器Excel
连接管理器失败，错误代码为0xC0209303。
可能有
错误消息之前发布的更多信息，为什么
AcquireConnection方法调用失败。此链接（将软件包从64位切换到32bit ）导致我将$ code> Run64BitRuntime 属性更改为 False 。
更改属性后，我现在收到一组不同的错误：
错误：0xC0202009在DynamicExcel，连接管理器Excel
连接管理器：SSIS错误代码DTS_E_OLEDBERROR。发生OLE DB
错误。错误代码：0x80004005。 OLE DB记录是
可用。资料来源：Microsoft JET数据库引擎Hresult：
0x80004005说明：Microsoft Jet数据库引擎不能
打开文件，它已经由另一个用户专门开放，
或您需要许可查看其数据。。
错误：0xC020801C在数据流任务，Excel目的地[24]：SSIS
错误代码DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER。
AcquireConnection方法调用连接管理器Excel
连接管理器失败，错误代码为0xC0202009。
AcquireConnection方法调用失败。 >解决方案
我有同样的消息，我在Visual Studio 2010上有一个SSIS项目，我在该页面上看到一个file.xls，在我的项目中VS 2010没有任何问题，当我试图存储一些查询结果到excel文件，给我一个'Microsoft.Jet.OLEDB.4.0'提供者没有在本地机器上注册'，我修正了这个问题，接下来这个步骤，
1.打开IIS
2. - 在高级设置上更改appPool
3 。-true可启用32位应用程序。
这些都是
ps.I将配置管理器更改为Active Solution Platform上的X86
I am using windows 8.1, office 2013, Visual Studio 2013, SQL Server 2014 and SSIS 12.0
I have a data flow which has OLE DB source, Data Conversion And Excel Destination.
My OLEDB Source
Data Conversion
I have create a Excel file StudentInfo.xls in (C:\XX) folder and make a connection
Everything is OK, but when I execute it I giving me the following errors:
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.
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.
and that's all
ps.I changed Configuration Manager to X86 on Active Solution Platform
这篇关于将数据导出到Excel文件从Sql Server 2014使用SSIS 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
