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.

RabbitMQ SSIS Component error: Could not load file or assembly ‘RabbitMQ.Client'

Discussion in 'Business Intelligence' started by Peter Schmitz, Jun 1, 2017.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    After installing the RabbitMQ source components for SSIS, I created a test package to see if I could actually get any data returned. However, when running the package, I was greeted with the following error:

    This is because the RabbitMQ client dll that the connection manager is using has not been registered to the Global Assembly Cahce (GAC). To do this, you will need to fire up the Developer Command Prompt for Visual Studio. On my machine, this was found in the installation folder for Visual Studio 2013 -> Visual Studio Tools.

    Make sure you run it as Administrator, or registering the DLL will fail.

    Once you're there, locate the path where the RabbitMQ client dll is located, and change the directory to that folder (In my case, this was the folder in which the Data Source component was created and built; i.e. C:\users\<username>\Documents\SSISRabbitMQ-master\SSISRabbitMQ-master\packages\RabbitMQ.Client.3.1.1\lib\net30). Then registering the DLL for use is as simple as issuing the following command:

    Code (text):

    gacutil -iF RabbitMQ.Client.dll
     
    If all goes well, you should see something like the followng message indicating the dll has now been added:

    Once that is done, you now ought to be able to run the package with the RabbitMQ connection manager.

Share This Page