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 it works...

As in the preceding recipe, the package traverses the specified folder and processes multiple files. In this particular case, each filename also contains the information about which clients it contains; for instance, the Clients_H-R.csv file contains data for clients whose names start with letters H to R. This information is used to prepare the person lookup query by storing the first letter in the lowerBoundary variable, and the last letter of the range in the upperBoundary variable. Both variables are referenced in the expression used to determine the value of the personLookupQuery variable, which is then used to configure the Person Lookup transformation at run time.

In each iteration of the Foreach File container, a new ...

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