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

Get ETL with Azure 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.