How to do it...

  1. Make sure that the AdventureWorksETL.sln solution is open in SSDT, and that the LookupExpression.dtsx package is active in the control flow designer. The solution is located in the C:\SSIS2016Cookbook\Chapter06\Starter\AdventureWorksETL\ folder.
  2. Create three new package variables using the following information; the Variables window can be opened by selecting Variables in the SSIS menu when an SSIS package is active in the control flow designer:

Name

Data type

lowerBoundary

String

upperBoundary

String

personLookupQuery

String

  1. Make sure the personLookupQuery variable is selected in the Variables window, and click the Move Variable icon (the second from the left) to change the variable's scope. ...

Get SQL Server 2017 Integration Services Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.