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. Make sure that the AdventureWorksETL.sln solution is open in SSDT, and that the LookupCache.dtsx package is active in the control flow designer. The solution is located in the C:\SSIS2016Cookbook\Chapter06\Starter\AdventureWorksETL\ folder.

This package is a variation of the package you developed in the preceding recipe; instead of processing a single source file, it uses the Foreach loop container to traverse a folder in the filesystem and process one or more files that correspond to the search criteria.

  1. From the SSIS Toolbox, drag a Data Flow component to the control flow designer, and change its name to Load Person Cache.
  2. Remove the precedence constraint leading from the Truncate Resolved Client task to the Foreach File ...

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