© Andy Leonard 2021
A. LeonardBuilding Custom Tasks for SQL Server Integration Serviceshttps://doi.org/10.1007/978-1-4842-6482-9_14

14. Implement New Connection

Andy Leonard1  
(1)
Farmville, VA, USA
 

In Chapter 13, we implemented GeneralView and made a good start of implementing SettingsView. This chapter is all about completing the SettingsView SourceConnection property implementation, which is the most complex part of building the Execute Catalog Package Task Complex editor (thus far, at least).

Implementing New Connection Functionality

To implement “<New Connection…>” functionality in the SourceConnection dropdown, we first need to add an event handler for changes to manage and respond changes in PropertyGrid values.

Begin by adding the code in Listing ...

Get Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond 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.