O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How it works...

To create a custom data flow component, you need to create a class that derives from the Microsoft.SqlServer.Dts.Pipeline.PipelineComponent base class, which provides the functionalities needed to configure the component at design time and perform the operations at run time. By implementing the DtsPipelineComponent attribute, you allow the class to be recognized as an SSIS component by SSDT at design time and by the SSIS execution engine at run time.

By overriding the ProvideComponentProperties() base class method, you established the essential elements of the component: the input, the output, and in it the output column to hold the result of the transformation. You defined the custom properties (two for the component and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required