Open topic with navigation

# 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

© Copyright 2019 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm