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

 

Answer 1

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>

 

Answer 2

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”

Answer 3

Still no luck

 

Answer 4

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)

Answer 5

 

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

 

Thanks

Answer 6

 

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.

Answer 7

 

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.

Answer 8

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

Answer 9

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.