The objective of this task is to teach you how to work with SSIS variables in a Script task. You will learn two ways, a more complex one and a simpler one. You will typically use the latter in your packages.
Using variables in SSIS Script task
Getting ready
There are no special prerequisites for this recipe, except, of course, SSIS 2016. In addition, you can use either your own text files for testing, or the three text files provided with the code for this chapter (Ch11_03.txt, Ch11_08.txt, and Ch11_10.txt).
For your convenience, the VB and C# code snippets needed for this chapter are provided in the Chapter11.txt file.