Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

The Excel Connection Manager is not supported in the 64-bit

WBOY
Release： 2016-06-07 17:40:53
Original
1081 people have browsed it

昨天朋友在64位环境开发SSIS的时候遇到一个问题：TheExcelConnectionManagerisnotsupportedinthe64-bitversionofSSIS,asnoOLEDBproviderisavailable.由于没有64

 昨天朋友在64位环境开发SSIS的时候遇到一个问题：


The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

 

由于没有64位的Microsoft OLE DB Provider for Jet,所以在64位机器上使用SSIS调用Excel会遇到两个问题，一个是开发的时候遇到错误，另外一个是部署SSIS的时候遇到这个错误。

 

解决开发错误将Debugging属性“Run64BitRuntime”值改为False：

 

 

 

解决JOB部署错误，服务器空间，将执行选项使用32位运行时环境:

 

问题解决，香港服务器，JOB运行成功：

 

 

本文出自 “关注SQL Server技术” 博客，请务必保留此出处

，免备案空间
Related labels：
The Excel Connection Manager 6
source：php.cn
Previous article： SQL Server中，实现二进制与字符类型之间的数据转换 Next article： 12306暴SQL注入漏洞？！这下乐大发了
Statement of this Website
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1895
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
10
2060
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1731
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1635
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1647
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template