Cannot Load Excel file through SSIS package deployed to SSMS

Lady Foley 1 Reputation point
2021-09-09T14:49:40.387+00:00

I've created an SSIS package that loads an Excel file to an SSMS with no problems.
When I deploy the package to SSMS and run the package from there I get the below error -
Error: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

I've tried absolutely everything to fix this.
I've downloaded the 32 bit AccessDatabaseEngine.exe and changed the SSIS package to run in 32 bit mode and also changed it in SSMS to run in 32 bit mode.
Just to be sure I also tried all of this but with 64 bit versions ..... still the same error.

My Excel, SSMS and Visual studio are all 32 bit. When looking at my system through Control Panel > System, my system type is 64 bit.

Is there any way at all I can get this working through SSMS? I've exhausted the internet for solutions. Can anybody help?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,496 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,566 Reputation points
    2021-09-09T15:16:30.08+00:00

    Hi @Lady Foley ,

    There is no need to run SSIS packages on a SSIS run-time server in a 32-bit mode.

    You need to downoad and install the Microsoft.ACE.OLEDB.12.0 64-bit on a server.
    https://www.microsoft.com/en-us/download/details.aspx?id=13255

    Here is a query to check if the Microsoft.ACE.OLEDB.12.0 64-bit is properly installed on the server:

    EXEC master.sys.sp_MSset_oledb_prop;  
    

    You should see it along the following:

    130710-microsoftaceoledb120.png

    0 comments No comments

  2. ZoeHui-MSFT 34,591 Reputation points
    2021-09-10T01:49:03.057+00:00

    Hi @Lady Foley ,

    The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered

    You may need to download the Access Database Engine 2010 64-bit.

    Microsoft Access Database Engine 2010 Redistributable

    Also take a reference of here, if you get error that you could not install the 64bit cause you have already the 32bit.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments No comments