Example: Assigning a Parameter to a Data Structure Column

You can assign a parameter to a data structure column whose source expression can be modified.

1. Create a parameter and call it SourceUserName.
2. Open a step's property sheet whose data structure columns can be modified.
3. Click the Data Structure Columns tab, and double-click a data structure column to open its property sheet.
4. Click the Data Structure Source Objects tab, and in the source expression box, click the Edit Source Expression tool to open the corresponding editor.
5. Click Parameters in the Source field to display the available parameters in the Source Columns field, position the cursor in the script textbox where you want to add the parameter, and then double-click the SourceUserName parameter to add it to the query script.
6. Complete the script as appropriate.
   
   
   
7. Click OK to close the dialog box.

   The source expression of the data structure column is updated.

   
   
   
8. Click OK to close the dialog box.