DAC: Text 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 text 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 Text data type.
   
5. Click in the Value field to open the Enter Parameter Value dialog.
   
6. Select one of the following options:
   
   • Static. This option specifies a value that remains constant for all ETL runs.
     
   • Runtime. This option specifies a value will be updated by the DAC before each ETL run.
     
7. If you selected the Static option, enter a text value in the text window, and click OK.
   
8. If you selected the Runtime option, select a DAC Variable from the list, and click OK.
   
9. (Optional) To inactivate the parameter, select Inactive.
   
10. Click Save.