© Andy Leonard 2021
A. LeonardBuilding Custom Tasks for SQL Server Integration Serviceshttps://doi.org/10.1007/978-1-4842-6482-9_6

6. Preparing to Build

Andy Leonard1  
(1)
Farmville, VA, USA
 

Building custom SSIS tasks is neither trivial nor easy. You are building components that will be used to construct software. Perhaps you have done this before. Many have not.

Building the assembly is straightforward, consisting of two steps:
  1. 1.

    Build the assembly.

     
  2. 2.

    Register the assembly in the Global Assembly Cache (GAC).

     
Recovering gracefully when the code does not perform as expected is key. When the build/register procedure fails to achieve the desired results, a developer can take the following steps to recover:

  • Unregister the assembly from the GAC.

  • Clean the ...

Get Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond 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.

Start your free trial