Transformations > Source Transformation > File Source Properties
  

File Source Properties

You can configure properties for file sources, such as flat file and FTP/SFTP.
The following table describes the file source properties:
File Property
Description
Connection
Name of the source connection.
Source Type
Source type.
Object
Source object for a single source.
Formatting Options
Flat file format options. Opens the Formatting Options dialog box to define the format of the file. You can choose either a delimited or fixed-width file type. The delimited file type is the default.
For a delimited flat file type, configure the following file format options:
  • - Delimiter. Delimiter character.
  • - Text Qualifier. Character to qualify text.
  • - Escape character. Escape character.
  • - Field labels. Determines if the task generates field labels or imports labels from the source file.
  • - First data row. The first row of data. The task starts the read at the row number that you enter.
For a fixed-width flat file type, select the fixed-width file format to use. If you do not have a fixed-width file format, go to Configure > Fixed Width File Formats to create one.