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_7

7. Coding the Task

Andy Leonard¹  

(1)

Farmville, VA, USA

 

We’ve worked through several chapters in preparation for this chapter, but we are finally ready to begin coding the custom task in earnest. We begin by adding references to the project, decorating the class, inheriting from a base class, and adding a property.

Using a Reference

Open the Visual Studio solution ExecuteCatalogPackageTask. In Solution Explorer, open the class ExecuteCatalogPackageTask.cs. In the top section of the class, add the line using Microsoft.SqlServer.Dts.Runtime;

Your class now appears as shown in Figure 7-1:

Figure 7-1

Using a reference

This line ...