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

© 2016 Hewlett Packard Enterprise Development LP | Send documentation feedback to HPE Close We welcome your comments! 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 AutonomyTPFeedback@hpe.com. Product: Topic Title: Help Topic: Feedback:

_HP_HTML5_bannerTitle.htm