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.

SSIS - Getting the RabbitMQ components to work for SQL Server 2014

Discussion in 'Business Intelligence' started by Peter Schmitz, May 22, 2017.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    We are trying to use the RabbitMQ components from GitHub. While attempting to do so, we ran into a few issues, so I figured I'd write a quick guide on what we did to get this to work.

    First, we downloaded the zip file, and unpacked it on my development server. Once it was unzipped, we opened the solutioni n Visual Studio. Our target server is SQL Server 2014, and the version of Visual Studio the package was opened in is Visual Studio 2013 (which is the same version we build our SSIS packages in).

    I started off by trying to get the Connection Manager to work. Initially, there were some warnings/errors thrown regarding the target architecture.

    To solve these, in Solution Explorer, ensure you selected the Solution, and then click on "Build" -> "Configuration Manager" -> "Platform" -> "New".

    Select x86 for all projects involved, even if you are running on an x64 environment. This is because Visual Studio still is a 32-bit application, and the components will not show up unless you build them for x86. (Trust me, I found out the hard way and struggled for 45 minutes to figure out why things weren't working).

    When attempting to then build the project would fail. The error message was

    If you look closely, you will notice it refers to SQL Server 110 in the path. However, SQL Server 2014 is version 12 (120). The solution is to change the pointers to the "DTS\Binn" folder in the 120 folder. You can also do this in the Configuration Manager (but this time highlight the project in Solution Explorer):

    "Build" -> "Configuration Manager" -> "Build Events" -> "Edit Post-build..."

    Edit the command line statement there to the following:

    This allowed me to build the solution. After that, we were able to open a new SSIS project and saw the RabbitMQ connector:

    RabbitMQConnector.PNG

    Repeat step 1 (adding the tagret platform) but this time, for x64, and then rebuild the whole solution.

Share This Page