Designing a custom transformation

To design a Custom Data Flow Component, you need to create a .NET assembly based on the Class Library Visual Studio template; the class with the component's definition must be derived from the PipelineComponent base class of the Microsoft.SqlServer.Dts.Pipeline namespace. The class also needs to implement the DtsPipelineComponentAttribute that allows the class to be identified as an SSIS component and to provide the essential properties of the component used in the development of SSIS data flows.

If you want to simplify the configuration of the component, you can provide a custom graphical user interface; otherwise, the Advanced Transformation Editor will be used to configure the component during SSIS package development.

The component also needs access to the interfaces and classes of the Microsoft.SqlServer.Dts.Pipeline.Wrapper namespace. Depending on the functionalities provided by the component, additional references might be needed to the Microsoft.SqlServer...