Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Installing custom SSIS DLLs

Discussion in 'General' started by Peter Schmitz, Jun 30, 2014.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    At work, we use Google Analytics (GA) a lot. I recently came across a product that allows you to connect to GA from SSIS.

    However, at the time of writing, it is only a bunch of DLLs, and requires registering these in the Global Assembly Cache by means of gacutil.exe. My SQL Server did not have Visual Studio installed, and thus no gacutil.

    The solution is to install the Windows SDK. This initially was not possible, and the installation quit with a non-descriptive error message. Researching yielded that it might be related to the Microsoft Visual C++ 2010 files that were installed on the machine. The theory is that the SDK is attempting to register similar (but older) DLLs. Uninstalling the C++ files through "Control Panel" -> "Programs and Features" did the trick.

    gacutil will then be present at: "C:\Program fils\Microsoft SDKs\Windows\v7.1\Bin" (location might differ for you). I added that to the PATH variable in order to be able to call it from a Dos Prompt.

    Open a DOS Prompt (Command prompt) using "Run as administrator". The command to register the DLLs then is:

    Code (text):
    gacutil.exe /i <path-to-dll>
    I.e., assuming the location of the DLLs is "c:\data":

    Code (text):
    gacutil /i c:\data\DotNesOpenAuth.dll

    I found that I also needed to update my .NET Framework for this particular download. OTo be specific, these DLLs require .NET Framework 4.5.2.
    Last edited: Jun 30, 2014

Share This Page