The Format as Text The Format as Text tool creates single or multiple text documents, using information provided by Input tools such as the Database Query (ODBC) tool. It requires no global settings. tool does not require any global configuration; it can be immediately added to a task.

To add a new Format as Text step to an existing task:

1. Open the relevant task (if creating a new task, see How to Create a Basic Task).
2. Either:

►

Click and drag the Format as Text icon from the Task Browser to the task Design area.

–OR–

►

From the task's Design tab, right-click on empty space and select New > Format > Format as Text.

3. In the General tab, Name the task step and, if required, choose an input data source.
   How Do I Do This?

   The General tab is used to Name and describe (Description) this task step.

   Tip: If this task instance makes use of two or more Format as Text steps, ensure the Name used is unique for each individual step.

   ►

   Use a Recordset — Enable this parameter if recordset data from a previous task step is required to form the document

   ■

   Input Recordset — Contains all available recordsets from steps previously created in the task

   For more information, go to the main General tab topic.

4. Go to the Formatting tab and create the text document.
   How Do I Do This?

   Document Generation Options

   From the Document Generation Options pane, you specify when a new document is generated:

   ►

   One Document — Generate a new document each time the Format as Text task step is run.

   ►

   New Document when column changes — Generate a new document each time the value in a specified column changes. Select the relevant column.

   ►

   New document for each row — Generate a new document for every record in the input recordset.

   Enter the required text, bringing in task data from the Task Browser as required.

   For more information, go to the main Formatting tab topic.

5. Go to the Options tab and select the relevant error handling options for this task step.

   How Do I Do This?

   The Options tab allows you to define how errors in this step are handled at task runtime.

   If an error occurs, you can decide whether the step should Continue processing, or terminate the step immediately (Abort Task).

6. Click  to save the task step.