Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond

Table of contents

1. Cover
2. Front Matter
3. 1. The Story of This Book
4. 2. Preparing the Environment
5. 3. Creating the Assembly Project
6. 4. Check in the Project Code
7. 5. Signing the Assembly
8. 6. Preparing to Build
9. 7. Coding the Task
10. 8. Coding a Simple Task Editor
11. 9. Signing and Binding
12. 10. Expanding Editor Functionality
13. 11. Minimal Coding for the Complex Editor
14. 12. Editor Integration
15. 13. Implement Views and Properties
16. 14. Implement New Connection
17. 15. Implement Use32bit, Synchronized, and LoggingLevel SettingsView Properties
18. 16. Refactoring SourceConnection
19. 17. Refactoring the SSIS Package Hierarchy
20. 18. Instrumentation and Validation
21. 19. Crushing Bugs
22. 20. Adding Synchronous Execution Properties
23. 21. Testing the Task
24. 22. Building the Setup Project
25. 23. Using the Execute Catalog Package Task in an SSIS Framework
26. 24. Deploying to Azure-SSIS
27. 25. Test the Task in Azure Data Factory
28. 26. Notes from My Experience
29. Back Matter