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. Open SQL Server Data Tools (SSDT) and create a new project using the Integration Services Project template. Place the solution in the C:\SSIS2016Cookbook\Chapter07\Solution folder and name the project AdventureWorksETL.
  2. Rename the default package UsingVariables.dtsx.
  3. Create a intCounter variable with data type Int32 and a default value of 0.
  4. Create a strFile variable of type String with the default value blank. Your Variables window should look like the following screenshot:
  1. Add a For Loop container to the control flow. Rename it LoopThreeTimes.
  2. Add a Foreach Loop container to the control flow. Rename it GetFileNames.

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