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:

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