If you’d like to watch the video that goes with this documentation article, see below or click here.

• From the left side options column, navigate to Date Sources > Bulk Sources > File.

  +

• On the File Data Sources window, click on the Create Bulk File button.

  

• On the New File Data Source window, click on the Text File.

  

• This will open the Text File Data Source window.

  

• Enter a Description for the data source.
• Column Separator – choose the type of column separator from the drop-down list. The options are:
  • CSV Delimited
  • Tab Delimited
  • Pipe Delimited
  • Customer Delimited – selecting this option will activate the adjoining text field where the user can enter a column separator other than CSV, Tab, or Pipe.
• Character Set – the two options are ANSI or OEM.
• Has Column Headers – mark this checkbox if the source file has column headers.
• Select file at runtime – when this checkbox is marked, the uploaded file will be used as a template to define the column headers, and no data from it will be processed.
• Source File – select the text file that will be used as the data source.
• Source Schema – if the source file does not have column headers, they can be defined here by clicking on Add Column.
  • Row No – automatically populated.
  • Column Name – user enters the name of the added column here.
  • Type – user defines the data type by selecting one of the dropdown list options.
  • Length – user defines the length of the field.
• Once all the fields have been populated, the Save button becomes active.
• Clicking on Save will save the data source and make the data source available to be selected when creating an Integration Process.
• After the Text File source has been saved, the Preview button will become active.
• Clicking on the Preview button opens a pop-up window that displays the first few records contained in the spreadsheet.