SQL Server 2005 SSIS Error Loading Type Library/DLL

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.

SS2005_IS_Error_Loading_Type_Library_DLL

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)

~ Adios

Khan

Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook |

Follow me on Twitter

Avatar

About Arsalan Khan

People know me as 'Khan' ... nope not Shah Rukh's movie but Star Trek II - Wrath of Khan and since than 'Khan' it has been. Born and raised in Dubai before moving to US for my masters. Been blessed with solid 8+ yrs with SQL (and counting) and currently working for the biggest publishing house as Sr. Database Administrator. I have had an opportunity to speak about tips & tricks to write efficient tsql for Quest International Users Group (PeopleSoft). Love playing TT, badminton and thoroughly enjoy watching cricket when not occupied with my loving daughter. Expertise in DR, Performance Tuning, Troubleshooting and Problem Solving. With that being said I have finally decided to roll my sleeves up and give back to the community bit by bit. Finally.. as my wonderful wife puts it ... "if you don't have a smile, I will give you one of mine ~ Rabia Khan" ~Cheers

View all posts by Arsalan Khan →

Leave a Reply

Your email address will not be published. Required fields are marked *