Custom connection properties used by the Delimited Text DSC
This topic describes the custom connection properties that are unique to the Delimited Text DSC.
You can specify custom connection properties by adding the MR Init Custom or MR Custom connection property to the connection string.
Format
MR [Init] Custom = "<property name> = <value> (; <property name> = <value>)*"
If the single characters "\" or ";" are used as the CsvFieldDelimiter, then the usage is as follows:
MR Init Custom = "CsvFieldDelimiter = \; ; UseMetaDataValues = 1"
MR Init Custom = "CsvFieldDelimiter = \\ ; UseMetaDataValues = 1"
Example
MR Init Custom = "CsvFieldDelimiter = ,; UseMetaDataValues = 1"
Use the MR Init Custom property when you connect using the , for example, in DM Query or in a data management (.dms) script. If you are passing connection properties to an Delimited Text DSC object that you have created programmatically, use the MR Custom property.
Connection properties
For a list of all the standard connection properties that are available to the Delimited Text DSC, see
Connection properties.
CsvFieldDelimiter
The character that the Delimited Text DSC must use as the delimiter character when reading from or writing to a .csv file. The default is a tab character.
Encoding
Specifies the CSV file encoding type. Possible values include:
UTF7
UTF8
UTF16 (the default value)
UTF32
ASCII
UseMetaDataValues
When writing a categorical response to a .csv file, a Long value that when set to 1 specifies that the Delimited Text DSC must write the value of the corresponding MDM category's IElementList_Value property (that is, the MDM mapped category value). The default is 0, which means that the Delimited Text DSC must write the index value of the corresponding MDM category.
When working with large datasets, or when reading categorical question values that are written as mapped values, you will want to set the property MR Init Custom=’UseMetaDataValues=1’ in the connection string. This will use the category name or category mapped value for category question(s) during data transformation, which will significantly increase performance when exporting data.
For more information, see "Single-response categorical variables" in
Variable definitions when writing to a .csv file.
See also