TechNet
Export (0) Print
Expand All

Multiple Flat Files Connection Manager Editor (Advanced Page)

 

Applies To: SQL Server 2016

Use the Advanced page of the Multiple Flat Files Connection ManagerEditor dialog box to set properties such as data type and delimiters of each column in the text files to which the flat file connection manager connects.

By default, the length of string columns is 50 characters. You can evaluate sample data and automatically 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.

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

Connection manager name
Provide a unique name for the Multiple Flat Files connection manager in the workflow. The name provided will be displayed within the Connection Managers area of 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.

PropertyDescription
ColumnTypeDenotes 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, which is terminated by the row delimiter.
OutputColumnWidthSpecify a value to be stored as a count of bytes; for Unicode files, this will display as 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: In the object model, the name of this property is MaximumWidth.
DataTypeSelect from the list of available data types. For more information, see Integration Services Data Types.
TextQualifiedIndicate whether text data is qualified using a text qualifier character:

 True: Text data in the flat file is qualified.

 False: Text data in the flat file is not qualified.
NameProvide a column name. The default is a numbered list of columns; however, you can choose any unique, descriptive name.
DataScaleSpecify the scale of numeric data. Scale refers to the number of decimal places. For more information, see Integration Services Data Types.
ColumnDelimiterSelect 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.

 {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
DataPrecisionSpecify the precision of numeric data. Precision refers to the number of digits. For more information, see Integration Services Data Types.
InputColumnWidthSpecify 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 dropdown list.

ValueDescription
Add ColumnAdd a new column at the end of the list.
Insert BeforeInsert a new column before the selected column.
Insert AfterInsert 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 first selected 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.

Integration Services Error and Message Reference
Multiple Flat Files Connection Manager Editor (General Page)
Multiple Flat Files Connection Manager Editor (Columns Page)
Multiple Flat Files Connection Manager Editor (Preview Page)

Community Additions

ADD
Show:
© 2016 Microsoft