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

Get SQL Server 2017 Integration Services Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.