BIDS – 32-bit Run time

BIDS is a 32-bit run time application (reference can be found here). So, when we are using SSIS we are using 32 bit facilities to build our package. Nowadays, we are using 64-bit OS and other hardware.

For Microsoft Jet Driver (MS Access or Excel), there is no 64-Bit version of Jet Driver so any packages using Jet driver (i.e. Excel or MS Access Database Connections) must be called using 32 bit DTExec. In this case, few tasks like Excel Source/Excel Destination will fail on running with following error messages.

  • 0x80040154 … Class Not Registered
  • The Acquire Connection method call to the connection manager XXX failed with error code 0xC0202009
  • 0xC00F9304 … SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED
  • The OLE DB provider “Microsoft.Jet.OLEDB.4.0” has not been registered

So, to run package in 32- bit run time. Go to Project -> Properties, change Run64BitRuntime to False, Apply and hit ‘Ok’.


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