Chapter 5: Extending SSIS with Custom Tasks and Transformations
In this chapter, you will learn how to extend the collection of natively provided SSIS Control Flow Tasks and Data Flow Components by designing a Custom Control Flow Task and a Custom Data Flow Component. By taking advantage of the built-in extensibility of SQL Server 2019 Integration Services (SSIS) you can implement your own solutions, or modules, to be used in SSIS control flows, or data flows. Furthermore, you can implement them in a way that makes them virtually indistinguishable from the natively provided ones.
This chapter covers the following recipes, aimed at introducing SSIS customization:
- Designing a Custom Control Flow Task
- Designing a Custom Data Flow Component
- Deploying SSIS customizations
- Upgrading a Custom Data Flow Component