Write Documents to Disk as SQL INSERT Statements

The SqlWriter 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.

The SqlWriter task can be configured as a Pre, Post, Update or Delete task.

To configure the task, specify the name of a section that contains the 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

For information about the parameters that you can use to configure this task, refer to the Connector Framework Server Reference.