Building Custom Tasks for SQL Server Integration Services, my latest book, is now available!
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.
The book is not about all the many SSIS custom tasks one may build. Instead, this book covers the “other stuff” – how to set up your coding environment, things that will trip you up, the moving parts and pieces required before a developer may begin the actual construction of an SSIS custom task. The sample project, while useful, is not Production-quality code (there is no validation, for example). the idea is to share the less-familiar requirements for building a custom SSIS task – the stuff that will trip you up unless you are an experienced .Net component developer.
Check it out! And please let me know what you think.