Open topic with navigation

# 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.

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

_HP_HTML5_bannerTitle.htm