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

16. Refactoring SourceConnection

Andy Leonard1  
(1)
Farmville, VA, USA
 
The goal of this chapter is to refactor ExecuteCatalogPackageTask methods related to the SourceConnection property . The goals are
  • Downgrade from SSIS 2019 to SSIS 2017 so as to run on the Azure platform.

  • Refactor connection identification to support the Server ➤ Integration Services ➤ SSIS Catalog ➤ Folder ➤ Project ➤ Package hierarchy.

  • Refactor the SettingsView.SourceConnection property.

  • Identify catalog, folder, project, and package objects in the Server ➤ Integration Services ➤ SSIS Catalog ➤ Folder ➤ Project ➤ Package hierarchy.

We also refactor ...

Get Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.