Building Custom Tasks for SQL Server Integration Services – Taking a low-cost approach to applying the power of .NET in ETL solutions
Learn to build custom SSIS tasks using Visual Studio Community Edition and Visual Basic. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you’ve already spent on licensing SQL Server. If you already have a license for SQL Server, then you do not need to spend more money to extend SSIS with custom tasks and components.
Why are custom components necessary? Because even though the SSIS catalog of built-in tasks and components is a marvel of engineering, there do remain gaps in the functionality that is provided. These gaps are especially relevant to enterprises practicing Data Integration Lifecycle Management (DILMS) and/or DevOps.
About Andy Leonard (Richmond, Virginia Author)
Andy Leonard is founder and Data Philosopher at Andy Leonard Consulting, founder and Chief Data Engineer at Enterprise Data & Analytics, an SSIS (Microsoft SQL Server Integration Services) Trainer and Consultant, Business Intelligence Markup Language (Biml) developer and architect, BimlHero, Microsoft SQL Server database and Integration Services developer and architect, Microsoft SQL Server data warehouse developer, community mentor, blogger, and engineer.
He is a co-author/author of twelve books: Andy is co-author of The Biml Book and SQL Server Integration Services Design Patterns, and author of Data Integration Life Cycle Management with SSIS, Building Custom Tasks for SQL Server Integration Services, Managing Geeks, and the Stairway to Integration Services series at SQL Server Central.