Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  64 Bit error: 80040154

Author  Topic  pjohnson Starting Member 1 Post Posted - 2011-08-31 : 20:54:09 Error: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154 I am receiving the above error on a windows 7 machine. I have a simple program that references ManagedDTS.dll that is compiled through visual studio for AnyCPU. Code: Application fred = new Application(); try { Package p = fred.LoadPackage(file, null); MessageBox.Show("yipee"); } catch (Exception ez) { MessageBox.Show(ez.Message); } When I run this program on an XP or XP 64bit PC with SSIS full installation (SSIS service installed) it runs successfully. On the 64 bit windows 7 box only client tools (64 bit) are installed and hence packages only run through bids. If i compile my program to run as x86 it runs fine on the windows 7 box but will not run as AnyCPU on that box - ie 64 bit. Why is this ? Looking at the ManagedDTS.dll it seems to be compiled as AnyCPU so thought it would run ok on a 64 bit windows 7 box as it runs ok on the 64 bit XP box. Only difference is the 64 bit XP box has a full install of SSIS but this should not matter as a 32 bit version still runs on the windows 7 box ? Any help greatly appreciated