- 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.
- From the SSIS Toolbox, drag a Data Flow component to the control flow designer, and change its name to Load Person Cache.
- Remove the precedence constraint leading from the Truncate Resolved Client task to the Foreach File ...