File source overview
When you configure the File Source endpoint in Replicate, you need to specify which row and column delimiters are used in your CSV source files as well as which characters are used to enclose columns containing delimiters. You may also need to specify which character is used to escape columns enclosed in double-quotes (should such columns exist in your source files). If you have previously used Replicate to transfer endpoint tables to files and you now wish to use those files as a source in another task, then you should specify the same delimiters (i.e. that were used to generate target files).
For more information, see Setting general connection properties.
Three types of delimited files are used in the Replicate Source File endpoint: