Building Custom SSIS Components


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 ( 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:

Developing a Custom Source Component:

Developing a Custom Destination Component:

SQLBits 8 - SSIS Custom Components: by Dave Ballantyne (I haven’t watched this yet)

🍪 I use Disqus for comments

Because Disqus requires cookies this site doesn't automatically load comments.

I don't mind about cookies - Show me the comments from now on (and set a cookie to remember my preference)