CODEWITHSUNDEEP
ssis
kdejarnet
kdejarnet

Reputation: 149

Error when trying to install SSIS 2005 Package on 64 bit OS

I've created an SSIS package on a 64 bit Windows 7 box running the 32 bit version of SQL Server 2005. When I try to install the package on a 64 bit Windows Server 2008 box running the 32 bit version of SQL Server 2005 I get the following error:

===================================

Unexpected error occurred. (Package Installation Wizard)

===================================

Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} 

failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application..ctor()
at Microsoft.SqlServer.Dts.Deployment.PackageInstallationWizardForm..ctor()
at Microsoft.SqlServer.Dts.Deployment.PackageInstaller.Main(String[] args)

===================================

Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} 

failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application..ctor()

I've also tried to install it on my Windows 7 box and got the same error. I have the same version of SQL Server 2005 running on our test server which is running 64 bit Windows Server 2003 and the installation wizard launches just fine.

On the Server 2003 box there isn't an assemblies folder in the C:\Program Files (x86)\Microsoft SQL Server\90\SDK so even though it's a 32 bit install of SQL Server the install is different. I'm figuring it was an upgrade from a previous version.

So far through my research I haven't found anything that's helped me correct this issue with the Server 2008 box. I'm assuming that the newer OS's or the clean installation of SQL server might be causing an issue but I'm only guessing at this point.

I've done a version check on all 3 instances of SQL Server using "SELECT @@VERSION" and have verified that all of the versions are 32 bit.

I've compiled my package on the Server 2003 box as well and it still won't install on the Server 2008 box. I've also set the Run64BitRuntime option to "False" in the package properties but so far nothing has helped.

Are there any files, such as dll's, that I need to transfer to the 2008 server from the 2003 server?

Any suggestions would be appreciated.

Upvotes: 0

Views: 1024

Answers (2)

kdejarnet
kdejarnet

Reputation: 149

As it turns out I needed to uninstall sql expess 2008. I'd read that sql server 2005 and sql express 2008 could exist on the same server which they can if they were only being used as database instances. Unfortunately the install of sql express 2008, which was already installed on the server, prohibited Integration Services and SQL Server Agent from working correctly and caused them to throw the errors mentioned.

Once sql express was uninstalled everything worked fine.

Thanks to everyone who responded.

Upvotes: 1

Mike Honey
Mike Honey

Reputation: 15027

This looks like a build error for your package. You need to track down what component is represented by that "component with CLSID ..."

Usually if you add the package to a BIDS SSIS Project and Execute it (debug it) the component with the issue will become clear.

Upvotes: 0

Related Questions