MS SQL 2005 SP2 x64 & SSIS Packages

Wed, 22 Aug 2007 15:25:37 Z

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

MS SQL 2005 SP2 x64 & SSIS Packages

Thu, 23 Aug 2007 15:40:01 Z

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

--After change

<ServerName>MySQLServer\MySQLInstancename</ServerName>

MS SQL 2005 SP2 x64 & SSIS Packages

Thu, 23 Aug 2007 17:02:54 Z

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”

MS SQL 2005 SP2 x64 & SSIS Packages

Thu, 23 Aug 2007 19:23:21 Z

Still no luck

MS SQL 2005 SP2 x64 & SSIS Packages

Thu, 23 Aug 2007 19:34:02 Z

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)

MS SQL 2005 SP2 x64 & SSIS Packages

Thu, 07 Feb 2008 00:06:33 Z

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

Thanks

MS SQL 2005 SP2 x64 & SSIS Packages

Thu, 07 Feb 2008 15:14:51 Z

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.

MS SQL 2005 SP2 x64 & SSIS Packages

Fri, 23 Jan 2009 20:39:28 Z

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.

MS SQL 2005 SP2 x64 & SSIS Packages

Tue, 27 Jan 2009 19:13:46 Z

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

MS SQL 2005 SP2 x64 & SSIS Packages

Mon, 02 Mar 2009 13:08:46 Z

RHudec said:

Here is what I did to resolve problem.

Hello,

I ran into the same issue and the solution described by RHudec above solved the problem - Thanks for the tip.