Configuration - SQL Server Integration Services Design Patterns - page 427

21. Click Add, and use these mappings:
a. Variable name: User::FileID
b. Data Type: LONG
c. Parameter Name: 0
22. Click OK to save the changes to the Execute SQL task.
23. Add a new Flat File connection manager, and point it to an existing
flat file.
24. Right-click on the Flat File connection manager, and select Proper-
ties.
25. Select the Expression property, and bring up the Property Expres-
sion editor.
26. Set an expression on the ConnectionString property that makes
use of the variable values retrieved from the PackageConfigura-
tion table. Listing 17-8 provides an example of the expression.
Listing 17-8 . Expression to Set the Path to the Input File on the Con-
nectionString Property
@[User::Directory] + "\\" + @[User::FileName]
Your package should now look like Figure 17-14 .