DAC:SQL Type Parameter

Procedure to define a parameter using the text data type. This procedure applies to parameters defined at both the source system and task levels.
To define a SQL type parameter:

1. Do one of the following:
   
   • To define a source system parameter, from the Views menu, select Design, and then select Source System Parameters.
     
   • To define a task level parameter, from the Views menu, select Design, then select Tasks, and then click the Parameters subtab.
     
2. Click New.
   
3. Enter a parameter name.
   
4. Select the SQL data type.
   
5. Click in the Value field to open the Enter Parameter Value dialog.
   
6. Select a Logical Data Source.
   
7. Enter a SQL statement, and click OK.
   
8. (Optional) To inactivate the parameter, select Inactive.
   
9. Click Save.