Export (0) Print
Expand All

Flat File Destination Editor (Connection Manager Page)

Updated: 15 September 2007

Use the Connection Manager page of the Flat File Destination Editor dialog box to select the flat file connection for the destination, and to specify whether to overwrite or append to the existing destination file. The flat file destination writes data to a text file. This text file can be in delimited, fixed width, fixed width with row delimiter, or ragged right format.

To learn more about the Flat File destination, see Flat File Destination.

Flat File connection manager

Select an existing connection manager by using the list box, or create a new connection by clicking New.

New

Create a new connection by using the Flat File Format and Flat File Connection Manager Editor dialog boxes.

In addition to the standard flat file formats of delimited, fixed width, and ragged right, the Flat File Format dialog box presents a fourth option, Fixed width with row delimiters. This option represents a special case of the ragged-right format in which Integration Services adds a dummy column as the final column of data. This dummy column ensures that the final column has a fixed width.

The Fixed width with row delimiters option is not available in the Flat File Connection Manager Editor. If necessary, you can emulate this option in the editor. To emulate this option, on the General page of the Flat File Connection Manager Editor, for Format, select Ragged right. Then on the Advanced page of the editor, add a new dummy column as the final column of data.

Overwrite data in the file

Indicate whether to overwrite an existing file, or to append data to it.

Header

Type a block of text to insert into the file before any data is written. Use this option to include additional information, such as column headings.

Preview

Preview results by using the Data View dialog box. Preview can display up to 200 rows.

Release History

15 September 2007

New content:
  • Described the Fixed width with row delimiters option that is available when you create a new connection.

Community Additions

ADD
Show:
© 2014 Microsoft