SSIS: Excel Connection Manager Error “Class not registered”

Recently, we were working on SSIS to get data from AX to the staging tables. As part of the requirement, we were also using Excel Connection Manager to read the data from one of the excel file and load it to a table.

After completing the development, we executed the package and it was successfully executed. Then, we deployed the package to SQL Server.

After deployment, when we executed the package it started giving us the below error:

“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. Description: Class not registered.”

To fix the issue, we executed the package from SQL Server in 32-bit mode by following the below steps:

  1. Select the package –> Right Click on it –> Select Execute

SSIS_1

2. Go to Advanced Tab –> Select 32-bit runtime –> Click OK.

SSIS_2

The package got executed successfully.

Hope it helps !!

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.