Rename the Class1.cs file in the project to CustomSSISComponent.cs.
#CREATE SSIS PACKAGE IN VISUAL STUDIO 2012 CODE#
The code I have presented here uses C#, but you can write it just as easily in Visual Basic also. You can name the project CustomSSISComponent. With that in mind, start by launching Visual Studio, and create a new class library project, as shown in Figure 1. I have tried to highlight specific tools between different versions wherever possible. If you are using an older version of either tool, you would have to adjust accordingly. In the next stage, once we are satisfied that we can deploy it, we’ll get it doing something useful.īefore we get into the details of building the class, note that the following description assumes that you are using Visual Studio 2012 and SQLServer Data Tools 2012. I’ve already mentioned that a data source component is used to read data from an external data source, but at this stage it won’t actually do anything. We will start by first building a bare-bones data source component, and then deploying it so that you can use it in your Integration Services package. SQLServer Data Tools automatically recognizes any class libraries in this folder that implement PipelineComponent, and makes the component available in the SSIS Toolbox. The compiled class library is placed in a subfolder in the SQLServer installation folder. It overrides the various methods of PipelineComponent, such as those for creating inputs/outputs, adding custom properties to the component etc. Net class that inherits from the PipelineComponent class, which is part of the overall SSIS Object Model. Under the hood, an SSIS data flow component is a. SQLServer Data Tools have some examples of data flow components, including the OLE DB Source, Lookup transformation and the Character Map transformation components. These can read data from external data sources, transform it, and write it back to other data destinations. In this article we will be specifically looking at data flow components. SSIS components are one of the basic building blocks of the SSIS framework, and can be found in the SSIS toolbox in SQLServer Data Tools.
#CREATE SSIS PACKAGE IN VISUAL STUDIO 2012 HOW TO#
In this article, we will look at how to extend this object model by building a custom data source, using a working example. Integration Services is so versatile because it has the ability to connect to disparate data sources built into its object model. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations. SQLServer Integration Services (SSIS) is the Microsoft platform for building enterprise-level data integration and data transformation solutions. Developing a Custom SSIS Source Component - Simple Talk