Building Custom SSIS Components

Introduction

I’ve been using SSIS for a long time and have always been curious about developing custom sources and destinations.

After having a bit of a look through the MDSN documentation (http://msdn.microsoft.com/en-us/library/ms345161.aspx) last night I thought I would give it a go.

So over the next couple of blog posts I’m going to attempt to create a custom Connection Manager, Source and Destination for RabbitMQ.

RabbitMQ is a widely used message broker built on the Advanced Message Queuing Protocol (AMQP).

Hopefully at the end of this series we will have:

  • Connection Manager which can be used by both the source and destination components which connects to the RabbitMQ broker
  • Source component which can read from a queue
  • Destination component which can send messages to an exchange

You can follow the source code updates in my GitHub repository.

The Series

As the series goes on I will add links to each article here.

Useful Resources

MSDN Documentation: http://msdn.microsoft.com/en-us/library/ms345161.aspx

Developing a Custom Source Component: http://msdn.microsoft.com/en-us/library/ms136088.aspx

Developing a Custom Destination Component: http://msdn.microsoft.com/en-us/library/ms135899.aspx

SQLBits 8 – SSIS Custom Components: http://sqlbits.com/Sessions/Event8/SSIS_Custom_Componenets by Dave Ballantyne (I haven’t watched this yet)

Advertisements

One thought on “Building Custom SSIS Components

  1. Hassan says:

    Hello,
    thank you very much for the great article and the code on gitHub.
    I was just curious, is the code on github open source?
    Many thanks in advance.
    Regards, Hassan

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s