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

Yesterday, a friend encountered a problem when developing SSIS in a 64-bit environment:

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

 

Because there is no 64-bit Microsoft ole db Provider for Jet, using SSIS to call Excel on 64-bit machines has two problems. One is that an error occurs during development, this error occurs when SSIS is deployed.

 

Solve the development error and change the value of the Debugging attribute "Run64BitRuntime" to False:

 

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/19192Q4I-0.png "border =" 0 "alt =" "/>

 

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/19192T3O-1.png "border =" 0 "alt =" "/>

 

Solve the JOB deployment error and use the 32-bit runtime environment for execution options:

 

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/19192R5J-2.png "border =" 0 "alt =" "/>

Solve the problem. The JOB runs successfully:

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/19192Q512-3.png "border =" 0 "alt =" "/>

 

For more information, see precautions for using Integration Services on 64-bit computers.

 

This article is from the "follow SQL Server Technology" blog, please be sure to keep this source http://lzf328.blog.51cto.com/1196996/1027082