Unravelled Development

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 ( 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).

SSRS Report Templates

In this post I will outline a very simple approach to creating a report template for your SSRS solution. Getting Started Create a new (or open an existing) reporting solution and add a new report, let’s call it _Template.rdl - this report will form the basis of our template. Open this report and add any standard formatting or style that you want for all future reports. Maybe you have standard header/footers, e.

Testing SSRS Reports

In this post I’ll outline how I used a project from Codeplex to write tests against SSRS reports. From the description from the project page: Allows testing reports deployed to reporting server 2008R2 or 2012 in Native or SharePoint mode. The tests cases are created in xml file in declarative form. Getting Started 1. Download and extract the latest release from the Codeplex site 2. Open the Settings.xml file, in here you will need to set a few different options: