© 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 ...

Get Building Custom Tasks for SQL Server Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.