1

I have a very simple SSIS package that takes data form an Excel sheet and dumps into a table. No Data conversion, a straight import. The package runs perfectly on Visual Studio but when deployed, I get the errors you see in the attached picture.

I also changed the project properties -> Debugging -> Run 64 bit runtime to False and re-deployed the package but the errors persist.

The requested OLE DB provider Microsoft.Jet.OLEDB 4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode

billinkc
  • 59,250
  • 9
  • 102
  • 159
Susie Dent
  • 73
  • 2
  • 6
  • 1
    My guess is that you don't have the driver installed in your SSIS server. – Luis Cazares Dec 23 '19 at 20:33
  • Yeah, it looks like a driver issue. If this is a one time thing, I would suggest converting the excel file into a csv and then importing. The challenges are lesser with csv. – CR7SMS Dec 23 '19 at 20:36
  • On the ssis server, if you are running it as a job, on the SQL Agent job configuration screen. You'll find it on the "Execution options" tab, check the option "use 32 bit runtime". – zip Dec 23 '19 at 20:38
  • The first thing I'd focus on is `The requested OLE DB provider Microsoft.Jet.OLEDB 4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode`. As the others have said, retry in 32 bit mode. The default is 64 bit – billinkc Dec 23 '19 at 22:16

1 Answers1

0

It's telling you that the OLE DB provider isn't installed. The 32 bit and 64 bit providers are separate installations. Might as well make sure both are installed.

Greg Low
  • 1,526
  • 1
  • 4
  • 4