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_5

5. Signing the Assembly

Andy Leonard¹  

(1)

Farmville, VA, USA

 

In order to be used by Visual Studio in SSIS projects, an SSIS custom task assembly must be signed. The .Net Framework includes tools for creating and managing “key” files which are used for signing assemblies.

Preparing to Add a Key

I recommend opening a command window as an Administrator to begin. Open the Windows Start menu and locate Command Prompt. Right-click Command Prompt, hover over “More,” and then click “Run as Administrator” as shown in Figure 5-1:

Figure 5-1

Opening an Administrator command window

When prompted, click the Yes button as shown in Figure ...