Advanced ETL Processor writes text output with the Text File Writer target. Use it when the next system expects CSV, tab-delimited, fixed-width, or another plain text layout instead of a database table. Plain text is not glamorous, but it still runs a surprising amount of business software.
What You Will Learn
- Configure a Text File Writer target.
- Choose delimited or fixed-width output settings.
- Review output data before using the file in another system.
- Adjust field names, field widths, headers, and footers where required.
Before You Start
Write a small test file first. Delimiters, encodings, and header rows are simple settings until one of them is wrong and the receiving system starts reading Tuesday as a customer name.
Text File Writer Docs
The Text File Writer documentation explains how to save transformation output into delimited or fixed-width files.
Review the Text File Writer properties before scheduling the job. This is where file name, delimiter, format, and other target settings need to match the system receiving the file.
Use the data view to inspect output rows, then switch to the data definition view when you need to rename fields or adjust widths for text files.
For formatted exports, also check field name formatting, headers and footers, and the general Writer documentation.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.