SqlWriterFieldNamesN
The names of the document fields that you want to include in the SQL insert statements created by the task. The fields that you specify are inserted into the columns specified by the corresponding SqlWriterColumnNamesN
parameter.
- To specify a field, type the field name.
- To specify a sub-field, type the field name, followed by a forward slash, followed by the name of the sub-field.
- To specify a field attribute, type the field name, followed by a forward slash, followed by the name of the attribute. Prefix the attribute name with the '
@
' character.
The SqlWriter
task always includes the DREREFERENCE
and DRECONTENT
document fields. Specify the columns that receive these values by using the SqlWriterDreReferenceColumnName
and SqlWriterDreContentColumnName
parameters.
If you specify a field that has multiple values, the SqlWriter
task writes only the first value.
Type: | String |
Default: | |
Required | Yes |
Configuration Section: | Any section you have defined for SqlWriter task settings |
Example: |
In this example, the data from the document field "documentField" is written to the column "tableColumn", and the data from the subfield "subField" is written to the column "subFieldColumn". |
See Also: |