SSISErrorCodeDTS_E_OLEDB_EXCEL_NOT_SUPPORTED
- WBOYOriginal
- 2016-06-07 15:22:381273browse
使用SSIS从数据库向excel导入数据时出现以下错误： 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. 这是由于机器是64位的，没有64
使用SSIS从数据库向excel导入数据时出现以下错误：
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.
这是由于机器是64位的，没有64位的OLE DB provider。
解决方法：在Project菜单中选择Properties,在左侧选择Degugging，将Run64BitRuntime属性置为False。然后再Execute Package，成功。
参考链接：http://wenku.it168.com/d_000602554.shtml
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Redis内部数据结构详解之双向链表（linkedlist）Next article：EBSfnd_new_messages表中的数据被误删的处理