© Andy Leonard 2021A. LeonardBuilding Custom Tasks for SQL Server Integration Serviceshttps://doi.org/10.1007/978-1-4842-6482-9_16
16. Refactoring SourceConnection
The goal of this chapter is to refactor ExecuteCatalogPackageTask methods related to the SourceConnection
. 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.