无法在 SSIS 2008 中读取 Excel 文件
我一直试图让 SSIS 2008 读取 Excel 文件。
昨天，我将我们的 SSIS 项目从 2005 年迁移到 2008 年，虽然升级说它有效，但我无法让它读取 Excel 文件。我在网上看到我需要将 JET 驱动程序升级到 Office 2007 (AccessDatabaseEngine.exe)，我就这样做了。瞧！一切开始工作了！
不幸的是，今天我重新启动了机器，一切又坏了。和以前一样的错误。我尝试重新安装JET驱动程序，甚至安装了SQLExpress 2008，我读到它也有升级的JET驱动程序。但无济于事。
我什至无法创建一个全新的 SSIS 项目/包，添加一个 Excel 连接管理器，指向一个简单的 Excel 文件，该文件由 A 列中的几个数字组成，添加一个新的数据流任务，然后在其中添加，使用绑定到 Excel 连接管理器添加 Excel 源。当我做这样简单的事情时，我得到：
未指定的错误（真正有帮助） SSIS 错误代码：DTS_E_OLEDBERROR 错误代码：0x80004005 来源：“Microsoft JET 数据库引擎” DTS_E_无法从连接管理器获取连接 Hresult: 0xC020801C
我没有 64 位 PC，但在重新启动 PC 之前一切正常。 我只有 Office 2003，并且安装了 SQL2008 开发工具。
任何帮助或建议将不胜感激。有没有办法获得更详细的故障信息？
I'm stuck trying to get SSIS 2008 to read an Excel file.
Yesterday, I migrated our SSIS project from 2005 to 2008, and though the upgrade said it worked, I cannot get it to read an Excel file. I read online that I needed to upgrade the JET drivers to Office 2007 (AccessDatabaseEngine.exe), which I did. And voila! Everything started working!
Unfortunately today, I rebooted my machine, and everything is broke again. Same error as before. I've tried re-installing the JET driver, and even installed SQLExpress 2008, which I read also has the upgraded JET driver. But to no avail.
I cannot even create a brand new SSIS project/package, add an Excel Connection Manager, pointing to a simple Excel file that I made up of just a few numbers in column A, add a new Data Flow Task, and w/in it, add an Excel source using bound to the Excel Connection Manager. When I do something as simple as this, I get:
Unspecified Error (real helpful)
SSIS Error Code: DTS_E_OLEDBERROR
Error Code: 0x80004005
Source: "Microsoft JET Database Engine"
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
Hresult: 0xC020801C
I don't have a 64bit PC, and I did have everything working until I rebooted my PC.
I only have Office 2003, and I have the SQL2008 Dev Tools installed.
Any help or suggestions would be appreciated. Is there a way to get more detailed information of the failure?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我在使用较新的 ACE 驱动程序在 x64 环境中阅读 Office 文档方面取得了更大的成功：
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=en
您的连接字符串将类似于：
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myfile.xls;Extended Properties="Excel 12.0 Xml;HDR=YES";
也许值得一试！
I've had more success in reading office documents on x64 environments using the newer ACE drivers:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=en
Your connection string will be something like:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myfile.xls;Extended Properties="Excel 12.0 Xml;HDR=YES";
Might be worth a try!