SqlWriter Task Parameters
The parameters in this section customize the SqlWriter
task.
This task writes document metadata and content to a file in the form of SQL INSERT statements. You can use the SQL to insert the data from the documents into a database.
The task always writes the document reference (DREREFERENCE
) and content (DRECONTENT
) fields, and you can choose the other fields that you want to include. The task writes one insert statement for each document that is processed.
You can configure the SqlWriter
task as a Pre, Post, Update or Delete task.
To configure the task, specify the name of a section that contains the task settings, for example:
[ImportTasks] Post0=SqlWriter:SqlWriting [SqlWriting] SqlWriterFileName=MyTask.sql SqlWriterTableName=table SqlWriterDreReferenceColumnName=REFERENCE SqlWriterDreContentColumnName=CONTENT SqlWriterFieldNames0=MODIFIED_DATE SqlWriterColumnNames0=DATE SqlWriterDataTypes0=DATE_TIME SqlWriterUseNullForMissingFields=true SqlWriterDateFormats0=DD/MM/YYYY SqlWriterDateFormats1=YYYY/MM/DD SqlWriterMaxSizeKBs=1024 SqlWriterArchiveDirectory=./SQLarchive