Export (0) Print
Expand All

Flat File Connection Manager Editor (Advanced Page)

Use the Advanced page of the Flat File Connection Manager Editor dialog box to set properties that specify how Integration Services reads and writes data in flat files. You can change the names of columns in the flat file, and set properties that include data type and delimiters for each column in the file.

By default, the length of string columns is 50 characters. You can resize the length of these columns to prevent truncation of data or excess column width. You can also update other metadata to enable compatibility with destination columns. For example, you might change the data type of a column that contains only integer data to a numeric data type, such as DT_I2. You can make these modifications manually, or you can click the Select Types button to use the Suggest Column Types dialog box to evaluate sample data and make some of these changes for you automatically.

To learn more about the Flat File connection manager, see Flat File Connection Manager.

Connection manager name

Provide a unique name for the flat file connection manager in the workflow. The name provided will be displayed within SSIS Designer.

Description

Describe the connection manager. As a best practice, describe the connection manager in terms of its purpose, to make packages self-documenting and easier to maintain.

Configure the properties of each column

Select a column in the left pane to view its properties in the right pane. See the following table for a description of data type properties. Some of the properties listed are configurable only for some flat file formats.

Property

Description

ColumnType

Denotes whether the column is delimited, fixed width, or ragged right. This property is read-only. Ragged right files are files in which every column has a fixed width, except for the last column. It is delimited by the row delimiter.

OutputColumnWidth

Specify a value to be stored as a count of bytes; for Unicode files, this value corresponds to a count of characters. In the Data Flow task, this value is used to set the output column width for the Flat File source.

Note Note

In the object model, the name of this property is MaximumWidth.

DataType

Select from the list of available data types. For more information, see Integration Services Data Types.

TextQualified

Indicate whether text data is surrounded by text qualifier characters such as quote characters.

Value

Description

True

Text data in the flat file is qualified.

False

Text data in the flat file is not qualified.

Name

Provide a descriptive column name. If you do not enter a name, Integration Services automatically creates a name in the format Column 0, Column 1 and so forth.

DataScale

Specify the scale of numeric data. Scale refers to the number of decimal places. For more information, see Integration Services Data Types.

ColumnDelimiter

Select from the list of available column delimiters. Choose delimiters that are not likely to occur in the text. This value is ignored for fixed-width columns.

Value

Description

{CR}{LF}

Columns are delimited by a carriage return-line feed combination.

{CR}

Columns are delimited by a carriage return.

{LF}

Columns are delimited by a line feed.

Semicolon {;}

Columns are delimited by a semicolon.

Colon {:}

Columns are delimited by a colon.

Comma {,}

Columns are delimited by a comma.

Tab {t}

Columns are delimited by a tab.

Vertical bar {|}

Columns are delimited by a vertical bar.

DataPrecision

Specify the precision of numeric data. Precision refers to the number of digits. For more information, see Integration Services Data Types.

InputColumnWidth

Specify a value to be stored as a count of bytes; for Unicode files, this will display as a count of characters. This value is ignored for delimited columns.

Note   In the object model, the name of this property is ColumnWidth.

New

Add a new column by clicking New. By default, the New button adds a new column at the end of the list. The button also has the following options, available in the drop-down list.

Value

Description

Add Column

Add a new column at the end of the list.

Insert Before

Insert a new column before the selected column.

Insert After

Insert a new column after the selected column.

Delete

Select a column, and then remove it by clicking Delete.

Suggest Types

Use the Suggest Column Types dialog box to evaluate sample data in the file and to obtain suggestions for the data type and length of each column. For more information, see Suggest Column Types Dialog Box UI Reference.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft