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 youcan 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)

Im getting the error above too. Nothing i have tried has sorted this out. Need help urgently. Thanks

Here is what I did to resolve problem. Resolution - By looking in the SP2 install logs we were able to confirm that the unregistering of these dlls had failed. So we manually unregistered both the 64 bit and 32 bit DTS.dll and MsDtsSrvrUtil.dll and then manually registered them using the regsvr32 utility.

Hi, I have run into this issue as well. There are 8 key DLL's that BIS uses. What I did was unregister and re-register each 32 Bit & 64 DLL (DLL's Listed below) and this issue was resolved. You'll notice that as you proceed throughunregistering and re-registering the 32 & 64 Bit DLL's that youmay recieve an error message when trying to unregister some DLL's. Thismaybe because the DLL was not registered in the first place... hence part of the problem. Ifyou recievethis message when trying to unregister a DLL, justproceedtoo registering the DLL. 64 Bit DLL Folder Location: Example --> C:\Program Files\Microsoft SQL Server\90\DTS\Binn 32 Bit DLL Folder Location: Example -->C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn To run the commands to unregister and register the DLL's go to"Start" / "Run" and enter the following commands below. The DLL's should be unregistered first and then registered. To Unregister a 64 Bit DLL use the following command below: regsvr32 /u "location of the DLL" ie:regsvr32 /u"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll" To Register a 64 Bit DLL use the following command below: regsvr32"location of the DLL" ie:regsvr32"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll" To Unregister a32 Bit DLL use the following command below: regsvr32 /u "location of the DLL" ie:regsvr32 /u"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTS.dll" To Register a32 Bit DLL use the following command below: regsvr32"location of the DLL" ie:regsvr32"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTS.dll" BIS 8 Key DLL's 1. DTS.dll2. DTSComExprEval.dll3. DtsConn.dll4. DTSLog.dll5. DTSPipeline.dll6. ExecPackageTask.dll7. MsDtsSrvrUtil.dll8. SQLTaskConnections.dll Hope this helps.

I have tried everything as show, in the unregister and register as well as some of the above. I am on the current sp II, hotfixes etc. I CAN perform the connect from my desktop, but not when I remote desktop, under sqladmin, which is 'god' on that server. I am still assuming it is a registration issue. I can NOT re-run the sp/hotfixes, as they will not let me select them, which makes sense since the add/remove programs shows them as already installed. one solution, although prod. svr, is to de-install those service packs etc. and = a re-do/reapply...bit dramatic to me. we are a 64 bit version, so wondering, do I need to do BOTH 32/64? also, the HTML example above is not showing the correct terminology word replacement, should give a better example. help rik

RHudec said: Here is what I did to resolve problem. Resolution - By looking in the SP2 install logs we were able to confirm that the unregistering of these dlls had failed. So we manually unregistered both the 64 bit and 32 bit DTS.dll and MsDtsSrvrUtil.dll and then manually registered them using the regsvr32 utility. Hello,I ran into the same issue and the solution described by RHudec above solved the problem - Thanks for the tip.

i have had same issue and it was resolved by doing what DJ Murphy has recommended. Problem surfaced when i applied SP3 on clustered instance of SQL Server 2005. Running maintenance plan stopped working. Thanks DJ Murphy.

copy following into a .bat file. regsvr32 /u "C:\Program Files\Microsoft SQL Server\90\dts\binn\dts.dll" regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\dts.dll" regsvr32 "C:\Program Files\Microsoft SQL Server\90\dts\binn\dts.dll" regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\dts.dll" regsvr32 /u "C:\Program Files\Microsoft SQL Server\90\dts\binn\DTSComExprEval.dll regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\DTSComExprEval.dll regsvr32 "C:\Program Files\Microsoft SQL Server\90\dts\binn\DTSComExprEval.dll regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\DTSComExprEval.dll regsvr32 /u "C:\Program Files\Microsoft SQL Server\90\dts\binn\DtsConn.dll regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\DtsConn.dll regsvr32 "C:\Program Files\Microsoft SQL Server\90\dts\binn\DtsConn.dll regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\DtsConn.dll regsvr32 /u "C:\Program Files\Microsoft SQL Server\90\dts\binn\DTSLog.dll regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\DTSLog.dll regsvr32 "C:\Program Files\Microsoft SQL Server\90\dts\binn\DTSLog.dll regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\DTSLog.dll regsvr32 /u "C:\Program Files\Microsoft SQL Server\90\dts\binn\DTSPipeline.dll regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\DTSPipeline.dll regsvr32 "C:\Program Files\Microsoft SQL Server\90\dts\binn\DTSPipeline.dll regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\DTSPipeline.dll regsvr32 /u "C:\Program Files\Microsoft SQL Server\90\dts\binn\ExecPackageTask.dll regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\ExecPackageTask.dll regsvr32 "C:\Program Files\Microsoft SQL Server\90\dts\binn\ExecPackageTask.dll regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\ExecPackageTask.dll regsvr32 /u "C:\Program Files\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll regsvr32 "C:\Program Files\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll regsvr32 /u "C:\Program Files\Microsoft SQL Server\90\dts\binn\SQLTaskConnections.dll regsvr32 /u "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\SQLTaskConnections.dll regsvr32 "C:\Program Files\Microsoft SQL Server\90\dts\binn\SQLTaskConnections.dll regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\90\dts\binn\SQLTaskConnections.dll

Thank you for the script. I can confirm this resolved my problem fully, and perfect timing as well as you only added the script yesterday. Simon

Thank you - I have spent all day trying to resolve this problem. Regards

Try this Solution 1) Open Command Prompt 2) cd "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn" && for %i in (*.dll) do %windir%\syswow64\regsvr32 /s %i