The Format as TextThe 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,
- Open the relevant task (if creating a new task, see How to Create a Basic Task).
|||Click and drag the Format as Text icon from the Task Browser to the task Design area.|
|||From the task's Design tab, right-click on empty space and select New > Format > Format as Text.|
- 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 enter the following details for the step:
Name — Enter a meaningful name for the 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.
Description — If required, enter a description of this 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.
- 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 columnchanges — Generate a new document each time the value in a specified column changes. Select the relevant column. New documentfor 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.
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).
Click to save the task step.