none
MS SQL 2005 SP2 x64 & SSIS Packages

    Question

  • 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

     

    Wednesday, August 22, 2007 3:25 PM

Answers

  •  

    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 dll’s 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.

    Thursday, February 7, 2008 3:14 PM

All replies

  • 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>

     

    Thursday, August 23, 2007 3:40 PM
  • 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”

    Thursday, August 23, 2007 5:02 PM
  • Still no luck

     

    • Proposed as answer by JamieJohnson Saturday, April 4, 2009 1:37 AM
    Thursday, August 23, 2007 7:23 PM
  • 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)

    Thursday, August 23, 2007 7:34 PM
  •  

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

     

    Thanks

    Thursday, February 7, 2008 12:06 AM
  •  

    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 dll’s 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.

    Thursday, February 7, 2008 3:14 PM
  •  

    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 through unregistering and re-registering the 32 & 64 Bit DLL's that you may recieve an error message when trying to unregister some DLL's.  This maybe because the DLL was not registered in the first place... hence part of the problem.  If you recieve this message when trying to unregister a DLL, just proceed too 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 a 32 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 a 32 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.dll
    2. DTSComExprEval.dll
    3. DtsConn.dll
    4. DTSLog.dll
    5. DTSPipeline.dll
    6. ExecPackageTask.dll
    7. MsDtsSrvrUtil.dll
    8. SQLTaskConnections.dll

     

    Hope this helps.

    • Proposed as answer by EricVDV Thursday, June 17, 2010 12:18 PM
    Friday, January 23, 2009 8:39 PM
  • 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

    Tuesday, January 27, 2009 7:13 PM
  • 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 dll’s 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.
    Monday, March 2, 2009 1:08 PM
  • 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.
    Friday, April 23, 2010 1:47 PM
  • 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
    Thursday, July 15, 2010 6:22 PM
  • 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

    Friday, July 16, 2010 1:53 PM
  • Thank you - I have spent all day trying to resolve this problem.

    Regards

    Wednesday, October 13, 2010 3:48 PM
  • 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

    Thursday, December 9, 2010 6:04 PM
  • Thanks a LOT, this script solve the problem, To error trying to unregistering dll but with it, it was fixed, thanks

    Thursday, April 25, 2013 5:09 PM