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