MS SQL 2005 SP2 x64 & SSIS Packages

On my local desktop, I can create and run ssis packages, when I try to do the same thing on server I get he following error right clicking on running packages or stored packages.

failed to retrieve data for this request. Library not Registered. (exception from HRESULT: 0x8002801D

there are 2 instances of SQL on this server. Both are named with one being use by SQLExpress and the other by SQL2005 Std

Give this a try; Integration Services installs just once no matter how many instances are installed on the machine. For the instance you are wishing to work with you can change the instance viewed by modifying C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml

Change the entry below to match your instance name.

--Prior to change

<ServerName>.</ServerName>

--After change

<ServerName>MySQLServer\MySQLInstancename</ServerName>

|||

Hi,

This is setup problem, partially discussed in this KB: http://support.microsoft.com/kb/919224

If reapplying SP2 to both instances does not work, please run the following command to manually fix it (the KB is to be modified soon):

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll”

|||Still no luck|||

I'm still getting same error. I do not have the hotfix installed do I need it?

Microsost SQL Server Management Studio

Failed to retrieve data for this request. ( Microsoft.SqlServer.SmoEnum)

Additional Information:

Library not registered.( Exception from HRESULT: 0x80002801D(TYPE_E_LIBNOTREGISTERED))

(Microsoft.SqlServer.DTSRuntimeWrap)

Library not registered.( Exception from HRESULT: 0x80002801D(TYPE_E_LIBNOTREGISTERED))

(Microsoft.SqlServer.DTSRuntimeWrap)