It is known that Intelligent Converters provides OraDump Export API to allow developers integrate corresponding capabilities into their applications. These capabilities are about export data from Oracle dump files into popular databases like Microsoft SQL server. Every developer having OraDump Export API can write just few lines of code on C# or Visual Basic to implement the appropriate export process. But what if someone requires to automate it? Obviously the proper task scheduler is necessary for this purpose. If destination database is hosted on Microsoft SQL server, SQL Server Integration Services (SSIS) would be the best choice.
However, SSIS requires that the assembly is registered in the Global Assembly Cache (GAC) and for this purpose it must be signed with "strong name" (assembly key). Only .NET components can be signed with "strong names", whereas OraDump Export API is an unmanaged COM DLL. So, it cannot be signed with "strong names" and added to GAC directly.
That's why it is necessary to wrap OraDump Export API component (ordecom.dll) into "Interop assembly" before using it with SSIS. It is possible to generate COM Interop assembly wrapper using the following steps (this manual is using Visual Basic, but the same steps could be applied for any other .NET compatible environment like C# or Java):
sn.exe -k KeyFile.snk
tlbimp.exe ordecom.dll /keyfile:KeyFile.snk /out:MyCOMInterop.dll