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.

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:

SqlWriterFieldNames0=documentField
SqlWriterColumnNames0=tableColumn
SqlWriterDataTypes0=CHAR
SqlWriterFieldNames1=documentField/subField
SqlWriterColumnNames1=subFieldColumn
SqlWriterDataTypes1=INT

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:

SqlWriterColumnNamesN

SqlWriterDataTypesN

SqlWriterDreReferenceColumnName

SqlWriterDreContentColumnName


_HP_HTML5_bannerTitle.htm