Wednesday, July 27, 2011

Problem connect to an Integration Service after SP install in SQL 2005

Many time I have had problem to connect to an Integration Service after SP 3 have been installed. The solution is to reregister the dll-s below.

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll