SSIS Error while loading data from Excel 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.

SSIS Error while loading data from Excel

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.

Resolution:

As said we need to run in 32bit mode.

While running locally using BIDS or SSDT make sure the project property Debugging => Run64BitRuntime is set to False.

In the SQL server 2012 job navigate to Configuration => Advanced and check the 32 bit run time option.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s