Microsoft – SQL Server – SQL Server Management Studio – Error Message – “Retrieving the COM class factory for component with CLSID {10030000-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154. (Microsoft.SqlServer.DtsObjectExplorerUI)”

Steps to recreate

  • Launch Management Studio (SQL Server Management Studio Version 2008/R2)
  • Connect to SQL Server Instance (in our case version 2000)
  • Navigate to the Instance’s Management \ Legacy \ Data Transformation Services node
  • Select one of the listed packages
  • Right click on your selection and from the drop-down menu, select the “Export..” menu item

ListDTSPackages

The error Message reads:

Textual:

TITLE: Open DTS 2000 Package
——————————

Retrieving the COM class factory for component with CLSID {10030000-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154. (Microsoft.SqlServer.DtsObjectExplorerUI)

Image:

RetrieveTheComClassFactory

If you click on the “Show technical details” button, you will see:

AdvancedInformation

Remediation Steps

Remediation Steps – Download Location

Microsoft SQL Server 2008 Service Pack 2 Feature Pack

Remediation Steps – Install Downloaded App

Download “Microsoft SQL Server 2008 Service Pack 2 Feature Pack” from  http://www.microsoft.com/en-us/download/details.aspx?id=6375
The first time we got an error message about unsupported OSes:

Image:

UnsupportedOS

If same happens to you, please return back to http://www.microsoft.com/en-us/download/details.aspx?id=6375 and click on “Install Instruction” button.

InstallInstuctions

and navigate to the “Microsoft SQL Server 2005 Backward Compatibility Components” section.

Within that section, based on the bitness of your client OS, choose the OS specific version.

Microsoft SQL Server 2005 Backward Compatibility Components

In our case, our OS is 64-bit and so we chose to download the x64 (SQLServer2005_BC_x64.msi).

Once downloaded we followed the well presented MS Windows Installation Steps.

Installation GUI Includes:

MicrosoftSQLServerv2005BackwardCompatibility_InstallationPath

Post Install Steps

Restart Management Studio processes.

And, retry export steps:

  • Connect to SQL Server Instance (in our case version 2000)
  • Navigate to the Instance’s Management \ Legacy \ Data Transformation Services node
  • Select one of the listed packages
  • Right click on your selection and from the drop-down menu, select the “Export..” menu item

If all is well, that is, it is everything you like about Sundays, you will see a screen that looks like the one pasted below:

SelectPackage

One of the things I like about DTS packages is that journaling is built in.

Leave a Reply

Please log in using one of these methods to post your comment:

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