locked
Error: Microsoft.jet.oledb.4.0 not registered on local machine when running the package from SQL Job RRS feed

  • Question

  • Hi.

    I am using Windows Server 2016. I have created a SSIS package in Visual studio which loads data from Excel and moves to SQL table ( script task functionality using c# )

    The above functionality works fine when run in Visual studio.  Microsoft Visual studio 2015 shell - version 4.7

    Target server version: SQL Server 2016

    The excel files I have is of type xls and xlsx

    I published the package from visual studio and created a custom job inside the SQL Server Agent and assigned the path of the package to the job.

    On running the application from the SQL Server Agent Job, I am getting error as  - Microsoft.jet.oledb.4.0 not registered on local machine. But it works , when run from visual studio.

    How to fix this?

    Thanks

    Monday, August 10, 2020 3:39 PM

Answers

All replies

  • Hi Venkatzeus,

    It is strongly recommended to start using Microsoft ACE OLEDB provider instead of the Microsoft Jet OLEDB provider.

    Jet provider is at least a decade old, and it comes just as a 32-bit edition.

    In essence, the Microsoft ACE OLEDB provider replaced the Jet.

    There are three ACE versions available. Just pick and use one of them.

    • Microsoft Access Database Engine 2010 Redistributable Download
      http://www.microsoft.com/en-us/download/details.aspx?id=13255
    • Microsoft Access 2013 Runtime (Microsoft.ACE.OLEDB.15.0)
      https://www.microsoft.com/en-us/download/details.aspx?id=39358
    • Microsoft Access Database Engine 2016 Redistributable 
      https://www.microsoft.com/en-us/download/details.aspx?id=54920

    • Proposed as answer by Naomi N Monday, August 10, 2020 7:25 PM
    • Unproposed as answer by Venkatzeus Tuesday, August 11, 2020 4:22 AM
    Monday, August 10, 2020 3:57 PM
  • Hi Venkatzeus,

    1.Please download Microsoft Access Database Engine 2010 Redistributable.

    2.Please install the ACE provider from the CMD.exe. Please refer to the following link:

       Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing

    Best Regards,

    Mona


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Tuesday, August 11, 2020 1:46 AM
  • HI.

    Thanks for the reply.

    When I run the application from visual studio, the same excel is processed and the data is moved to SQL table.

    When I run the application from the SQL Job, then this error is shown.

    In visual studio for the project properties - under debugging: Run64BitRunTime is set to false
    • Edited by Venkatzeus Tuesday, August 11, 2020 4:38 AM
    Tuesday, August 11, 2020 4:23 AM
  • Hi Venkatzeus,

    May I know if you download the Microsoft ACE provider?

    May I know if you execute the job by using 32 bit runtime?

    Best Regards,

    Mona


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Tuesday, August 11, 2020 5:42 AM
  • Hi Venkatzeus,

    May I know if you have anything to update?

    Best Regards,

    Mona


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    • Marked as answer by Venkatzeus Thursday, August 20, 2020 6:59 AM
    • Unmarked as answer by Venkatzeus Thursday, August 20, 2020 6:59 AM
    Friday, August 14, 2020 8:22 AM
  • Hi . Apologies for the delay.

    The issue is reolved by -  execute the job by using 32 bit runtime  in the job properties

    Thursday, August 20, 2020 6:59 AM