64 bit provider loading .xlsx

Question

Hi !

I have Installed excel 12.0 in the server to load .xlsx files. But still i couldn't see the driver in the Connection Strings w.

Please see the below screen shot.

Please help me what shall i do to see the provider to load .xlsx files.

Thank you !

---

Regards,

Answer 1

Hi ,

I think this help u little to run excel file in ssis.In instal  Access bit not work well on ssis any version.you need to change debugging 1 option from  true to false.

This is the step for change it:

1. Right click on your project then go to properties.

2.then go to debugging.

3.Then there is a option debug.go there and change "Run64bitRuntime"  true to false.

I think your problem solve.

Told me if u not understand anything my English so bad

If its not work ask me i try alt solution

Thanks

Muzahid.

Answer 2

You don't need office on your server (not recommended and not supported). You should install Microsoft Access Database Engine 2010 Redistributable for excel (xlsx) files and then use the Excel Connection Manager and Excel Source. Also see http://microsoft-ssis.blogspot.com/2014/02/connecting-to-excel-xlsx-in-ssis.html for 32 and/or 64bit.

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 3

I couldn't set Run64bitRuntime option or change the option. That option is disabled by default.

---

Regards,

Answer 4

you can use this

http://www.microsoft.com/en-in/download/details.aspx?id=13255

Also see this

http://blog.oraylis.de/2011/05/ssis-goodie-1-excel-ssis-64-bit-dts_e_oledb_excel_not_supported/

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

Answer 5

I couldn't set Run64bitRuntime option or change the option. That option is disabled by default.

---

Regards,

Step 1:

Change place:

And also install Microsoft Access Database Engine 2010 Redistributable  this. i think its help you.

thanks

Answer 6

Hi Bhadri,

Since the BIDS/SSDT is a 32-bit application, 64-bit providers/drivers are not visible in the IS design surface. So, we need the 32-bit providers to develop the package in BIDS/SSDT. After deploying the package to the SSIS Server or SSISDB catalog database, we can run the package in 64-bit runtime to make use of 64-bit drivers.

You can use the Excel Source or OLE DB Source to connect to the Excel source file when developing the pacakge. The Excel Source can automatically use the proper Microsoft ACE 12.0 OLE DB driver to connect to an Office Open XML format file (.xlsx). To obtain the 32-bit Microsoft ACE 12.0 OLE DB drivers, we can install the 32-bit version of Microsoft Access Database Engine 2010 Redistributable. After that, the Microsoft ACE 12.0 OLE DB Provider will be available in the IS design surface. 

If you need to run the package in 64-bit runtime mode after deploying the package, you need to install the 64-bit Microsoft Access Database Engine 2010 Redistributable on the SSIS server. Please note that the 32-bit and 64-bit Microsoft Access Database Engine 2010 Redistributables cannot be installed side by side on a single server, however, 32-bit (or 64-bit) Office and 64-bit (or 32-bit) Microsoft Access Database Engine 2010 Redistributable can be installed side by side.

In addition, the Run64BitRuntime option is disabled natively in SSDT 2012 when it is integrated with Visual Studio 2012.

Regards,

---

Mike Yin
TechNet Community Support

Answer 7

Hi Bhadri,

The error occurs because the Microsoft Jet OLE DB has only 32-bit version, however, the SSIS server runs the package in 64-bit runtime mode which requires the 64-bit drivers. Besides, you said that any of the connections failed if you checked the “use 32 bit runtime” option, it should be that only 64-bit drivers for other connections are installed on the SSIS server. So, you can address the issue by using one of the following approaches:

• Install 32-bit drivers for other connection managers as you did on the develop server, and run the package in 32-bit runtime mode.
• Install 32-bit Microsoft ACE 12.0 OLE DB drivers on the develop server, use an OLE DB Source adapter to connect to the Excel source file (.xls or .xlsx) when developing the package. When creating the OLE DB Connection Manager, you need to select the Microsoft ACE 12.0 OLE DB Provider, and specify the Extended Properties for the connection to Excel 12.0 no matter the source file is .xls or .xlsx. On the SSIS server, install the 64-bit Microsoft ACE 12.0 OLE DB drivers so that you can run the package in 64-bit runtime mode.

Regards,

---

Mike Yin
TechNet Community Support

Answer 8

Hello what version ssis you use.. Bhadri1991

as i cheek ssis 2012 and 2008 both version  Run64BitRuntime option  available and it not disable

Thanks ...

Answer 9

Hello what version ssis you use.. Bhadri1991

as i cheek ssis 2012 and 2008 both version  Run64BitRuntime option  available and it not disable

Thanks ...

It is disabled for SSIS 2012 projects in Visual Studio 2012:

http://www.microsoft.com/en-au/download/details.aspx?id=36843

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 10

Hello what version ssis you use.. Bhadri1991

as i cheek ssis 2012 and 2008 both version  Run64BitRuntime option  available and it not disable

Thanks ...

It is disabled for SSIS 2012 projects in Visual Studio 2012:

http://www.microsoft.com/en-au/download/details.aspx?id=36843

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Hello Ilionx.com  Please check  the mark on jpg.U need to instal 64 bot runtime for it... as my ssis 2012 its enable i use all 64 bit environment.I am new in ssis if there is something i say wrong accept its as newbie.