Flat File Destination

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 Expression Reference, Using Property Expressions in Packages, and Destination Custom Properties.

This destination has one output. It does not support an error output.

Configuring the Flat File Destination

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:

• Flat File Destination Editor (Connection Manager Page)
• Flat File Destination Editor (Mappings Page)

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:

• Common Properties
• Source Custom Properties

For more information about how to set the properties, click one of the following topics:

• How to: Set the Properties of a Data Flow Component Using a Component Editor
• How to: Set the Properties of a Data Flow Component in the Properties Window
• How to: Set the Properties of a Data Flow Component Using the Advanced Editor

See Also

Concepts

Flat File Source
Creating Package Data Flow

Other Resources

Integration Services Sources

Help and Information

Getting SQL Server 2005 Assistance

Change History