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

_HP_HTML5_bannerTitle.htm