O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

  1. In File Explorer, right-click the Ch07_08.txt file and select Properties, as shown in the following screenshot:
  1. Note the file size, 8 bytes. Click OK.
  2. In SSDT, add a new package to the Chapter07 project. Rename it FileSizes.dtsx.
  1. Add two variables to the package:
    • intSize, with data type Int64, and default value 5
    • objList, with data type Object, default System.Object
  2. Add a new Script task to the control flow. Rename it FilesBySize.
  3. Open the task editor. This time, use the Microsoft Visual C# 2015 language. Add the User::intSize variable to the ReadOnlyVariables and the User::objList variable to the ReadWriteVariables ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required