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

© Andy Leonard 2021

A. LeonardBuilding Custom Tasks for SQL Server Integration Serviceshttps://doi.org/10.1007/978-1-4842-6482-9_15

15. Implement Use32bit, Synchronized, and LoggingLevel SettingsView Properties

Andy Leonard¹  

(1)

Farmville, VA, USA

 

In Chapters 13 and 14, we implemented GeneralView and SettingsView. In this chapter, we implement additional SettingsNode properties – Use32bit, Synchronized, and LoggingLevel. Adding the SourceConnection property was intense, so we begin this chapter by adding one straightforward and simple property implementation: User32bit. Be forewarned, the intensity increases.

Specifying a 32-Bit Interface

SSIS is provider-agnostic, which means SSIS can connect with just about any data provider installed on a server. ...