Deploying Custom SSIS 2012 Component

Question

I am trying to deploy a basic custom component, following the documentation here

My code for the custom component is as follows:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.SqlServer.Dts.Pipeline;

namespace MattsCustomComponent
{
    [DtsPipelineComponent (DisplayName = "Matts Custom Component", ComponentType =    ComponentType.Transform)]
    public class MattsCustomComponent : PipelineComponent
    {
        public override void ProcessInput(int inputID, PipelineBuffer buffer)
        {
            int numberOfRows = buffer.RowCount;
            bool eof = buffer.EndOfRowset;
        }

    }
}

As you can see it is very basic. But when I deploy the dll to the GAC and to C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents

It doesn't appear in the SSIS toolbar, am I missing something in adding custom components? the guides online all seem to say that you just need to copy the dll to the gac and the relevant folder.

Matthew Wilson Matthew Wilson · Accepted Answer · 2015-03-12T10:17:24

The issue that I had here was that after further investigation we have discovered that to use visual studio 2012, you need to have SQL Server 2012 installed when working with ssis projects.

If a custom component has been built with sql server 2008 assemblies, the component will only be available to use in visual studio 2008.

If a custom component has been built with sql server 2012 assemblies, the component will only be available to use in visual studio 2012.

For now the only solution is to install visual studio 2008 and migrate the project to Visual Studio 2012 once we have also migrated to SQL Server 2012.

Deploying Custom SSIS 2012 Component

3 Answers