delimiter
: the delimiter character, use U+#### syntax (e.g. U+0001) for unicode characters
textQualifier
: the text qualifier character, e.g. " (which would be represented as "")
headerRowsToIgnore
: the number of records from the top of the file to ignore before the data starts (includes column header)
path
: the path to the source file to load, this can reference an execution parameter (e.g. @file_path)
encoding
: the encoding of the file, defaults to UTF8 if not specified, but also supports UTF8_BOM, ASCII, and UTF16
<DelimitedDataSourcedelimiter=","textQualifier="""headerRowsToIgnore="0"path="C:\Users\Cinchy\Sample.csv" encoding="UTF8"><Schema><Column name="firstname" ordinal="1" dataType="Text" maxLength="50"isMandatory="false" validateData="false" trimWhitespace="true" description=""/><Column name="lastname" ordinal="2" dataType="Text" maxLength="50"isMandatory="false" validateData="false" trimWhitespace="true" description=""/><CalculatedColumn name="lob" formula="@lob" dataType="Text" maxLength="100"isMandatory="false" validateData="false" description="" /><CalculatedColumn name="name" formula="CONCAT(firstname, lastname)"dataType="Text" maxLength="100" isMandatory="false" validateData="false"description="" /><Column name="net worth" ordinal="3" dataType="Number" maxLength="50"isMandatory="false" validateData="true" trimWhitespace="true" description=""><Transformations><StringReplacement pattern="\$" replacement="" /></Transformations></Column></Schema><Filter/></DelimitedDataSource>