You can output data to a flat file in either of the following ways:
Use a flat file target definition.
Create a mapping with a flat file target definition. Create a session using the flat file target definition. When the Integration Service runs the session, it creates the target flat file or generates the target data based on the connected ports in the mapping and on the flat file target definition. The Integration Service does not write data in unconnected ports to a fixed-width flat file target.
Use a relational target definition.
Use a relational definition to write to a flat file when you want to use an external loader to load the target. Create a mapping with a relational target definition. Create a session using the relational target definition. Configure the session to output to a flat file by specifying the File Writer in the Writers settings on the Mapping tab.
You can configure the following properties for flat file targets:
You can define target properties such as partitioning options, merge options, output file options, reject options, and command options.
Flat file properties.
You can choose to create delimited or fixed-width files, and define their properties.