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