Building Custom Tasks for SQL Server Integration Services

© Andy Leonard 2017

Andy Leonard, Building Custom Tasks for SQL Server Integration Services, 10.1007/978-1-4842-2940-8_5

5. Coding the Task

Andy Leonard¹ 

(1)Farmville, Virginia, 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 start 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.vb. At the very top of the class, add the following line:

Imports Microsoft.SqlServer.Dts.Runtime

Your class now appears as shown in Figure 5-1.

Figure 5-1. Using a reference ...