As part of consolidation for a client, I came across a minor issue with SQL Server 2005 SSIS. While opening SQL Server 2005 SSIS there was an error ‘Loading Type Library/DLL‘. The first thing I crossed checked was if I was using the correct SSMS version and no issues there. Looked at the error one more time – SQL Server 2005 SSIS Error Loading Type Library/DLL – and it clicked, I ran into the same issue with SQL Server 2012 SSIS.
MSFT has this ironed out in KB919224. But in my scenario we were already patched to the latest SP during early 2013.
Here is what the environment looked like:
OS – Win 2003 Enterprise x64 Sp2
SQL – SS05 Enterprise x64 9.0.5000
Resolution is simple, execute the following via cmd:
%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"
%windir%\system32\regsvr32 "%ProgramFiles%\Microsoft SQL Server\90\dts\binn\dts.dll"
%windir%\system32\regsvr32 "%ProgramFiles%\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll"
On each execution you will see a success splash screen message. Once completed go ahead and fire up your SSIS :). (in rare cases you will need to restart SSIS services)