Flat File Destination
Applies To: SQL Server 2016
The Flat File destination writes data to a text file. The text file can be in delimited, fixed width, fixed width with row delimiter, or ragged right format.
You can configure the Flat File destination in the following ways:
Provide a block of text that is inserted in the file before any data is written. The text can provide information such as column headings.
Specify whether to overwrite a data in a destination file that has the same name.
This destination uses a Flat File connection manager to access the text file. By setting properties on the Flat File connection manager that the Flat File destination uses, you can specify how the Flat File destination formats and writes the text file. When you configure the Flat File connection manager, you specify information about the file and about each column in the file. For example, you specify the characters that delimit columns and rows in the file, and you specify the data type and the length of each column. For more information, see Flat File Connection Manager.
The Flat File destination includes the Header custom property. This property can be updated by a property expression when the package is loaded. For more information, see Integration Services (SSIS) Expressions, Use Property Expressions in Packages, and Flat File Custom Properties.
This destination has one output. It does not support an error output.
You can set properties through SSIS Designer or programmatically.
For more information about the properties that you can set in the Flat File Source Editor dialog box, click one of the following topics:
The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics:
For information about how to set the properties of a data flow component, see Set the Properties of a Data Flow Component.