Knowledge Base

Creating a Text File Source

How can we help?

Browse Common Categories

Getting Started with

Creating a Text File Source

  • 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.
  • Click on the Preview button will open a pop-up window that displays the first few records contained in the spreadsheet.

Email an Expert

Start a Ticket

Chat with Us


Submit a Ticket


Call Us

  • Microsoft Dynamics 365
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2022 SmartConnect|eOneSolutions
Cloud Terms of ServicePrivacy PolicyTerms of ServiceEULA

How can we help?