Flat File Source Editor (Columns Page)
Use the Columns node of the Flat File Source Editor dialog box to map an output column to each external (source) column.
Note
The FileNameColumnName property of the Flat File source and the FastParse property of its output columns are not available in the Flat File Source Editor, but can be set by using the Advanced Editor. For more information on these properties, see the Flat File Source section of Source Custom Properties.
To learn more about the Flat File source, see Flat File Source.
Options
- Available External Columns
View the list of available external columns in the data source. You cannot use this table to add or delete columns.
- External Column
View external (source) columns in the order in which the task will read them. You can change this order by first clearing the selected columns in the table, and then selecting external columns from the list in a different order.
- Output Column
Provide a unique name for each output column. The default is the name of the selected external (source) column; however, you can choose any unique, descriptive name. The name provided will be displayed within SSIS Designer.
See Also
Reference
Flat File Source Editor (Connection Manager Page)
Flat File Source Editor (Error Output Page)
Other Resources
Integration Services Error and Message Reference
Flat File Connection Manager
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
5 December 2005 |
|