Situation:
We needed to install SSIS on a server running 64-bit-MS SQL Server 2005 SP3 with Cumulative update package 2 for SQL Server 2005 Service Pack 3 (9.0.4211) to support a SQL Server Agent job running a dtsx-package includes flatfile sources and destinations.
Problem:
Trying to register SSIS in SQL Server management Studio 2005 we received this Error:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) ...
Connect to SSIS Service on machine "ComputerName" failed:
Error loading type library/DLL.
The SQL Server Agent job failed, showing a similar error message stating the package could not be loaded.
Solution:
If the versions of the instances of SQL Server 2005 are not earlier than SQL Server 2005 SP2, run the following command at a command prompt to register the 32-bit Dts.dll file:
%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll"
You may also need to manually register MsDtsSrvrUtil.dll, using
%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll
If running 64-bit Integration Services, you may need to manually register the 64-bit dlls using these commands
%windir%\system32\regsvr32 "%ProgramFiles%\Microsoft SQL Server\90\dts\binn\dts.dll
%windir%\system32\regsvr32 "%ProgramFiles%\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll
Link: http://support.microsoft.com/kb/919224/en-us
Abonnieren
Kommentare zum Post (Atom)
Keine Kommentare:
Kommentar veröffentlichen