---
title: "Agent Column Case Configuration"
canonical: "https://docs.perspectium.com/space/helium/2113591/Agent%20Column%20Case%20Configuration"
format: markdown
---
The DataSync Agent supports forcing of the column name to a configured case.   This configuration must be done prior to the Agent creating the table.   Two directives are available for inclusion within the  agent.xml  configuration file. The chosen directive must be placed within the  <task>  tag. You would use either of these directives in your  agent.xml :  <lowercase_columns/>
<uppercase_columns/> Example of agent.xml <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
    <agent>
        <subscribe>
            <task>
                <task_name>example_subscribe</task_name>
                <message_connection password="encrypt:XXXX" user="XXXX" queue="..." >amqp://example.perspectium.net</message_connection>
                <instance_connection password="encrypt:XXXX" user="XXXX">http://example.service-now.com</instance_connection>
                <handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
                <decryption_key>The cow jumped over the moon</decryption_key>
                <database_type>sqlserver</database_type>
                <database_server>MyAddress</database_server>
                <database_port>1433</database_port>
                <database_user>XXXX</database_user>
                <database_password>XXXX</database_password>
                <database_parms></database_parms>
                <database>psp_repl</database>
 
                <uppercase_columns/>
 
            </task>            
        </subscribe>
        <max_reads_per_connect>2000</max_reads_per_connect>
        <polling_interval>5</polling_interval>    
    </agent>
</config> The default (none of these directives) simply uses the original case of the column. If you happen to specify both, uppercase will be used.   NOTE : T his directive affects column names only. It does not affect table names.