Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Leverage the power of Microsoft .NET for your data integration and ETL processes without incurring additional costs beyond your SQL Server licensing. This edition includes a demonstration of deploying a custom SSIS task to the Azure Data Factory (ADF) Azure-SSIS Integration Runtime (IR). All examples are implemented in C#, the default language for .NET development. Custom components are essential due to gaps in the built-in SSIS functionality. For instance, the built-in Execute Package Task does not allow selection of SSIS packages from other projects in the SSIS Catalog. This book provides guidance on creating a custom Execute Catalog Package task to overcome this limitation. By following the examples and patterns presented, SSIS developers can craft tailored tasks to meet their specific data integration needs. You will learn to configure Visual Studio for SSIS task development, create a class library for SSIS tasks, sign assemblies for invocation, implement source code control with Azure DevOps or other tools, troubleshoot custom tasks, create deployment projects (MSIs) for distributing tasks, and deploy custom tasks to Azure Data Factory Azure-SSIS IRs. Additionally, you will discover how to create advanced editors for custom task parameters.
