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

2. Preparing the Environment

Andy Leonard1  
(1)
Farmville, VA, USA
 
One of the first things martial arts students are taught is how to fall. Why? So they don’t hurt themselves. Before we begin developing this task, I want you to know: you are going to experience failures. Tests will fail, code will not behave as anticipated, and things will go wrong. When they do, I want you to accept a couple universal truths of software development:
  1. 1.

    Failure is normal.

     
  2. 2.

    How to recover.

     

I cannot overemphasize the need for lifecycle management, of which source control is central. I use Microsoft Azure DevOps, but feel free to use any ...

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