<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd">
<etl>
    <description>ETL script for bulk upload platform and pin</description>

    <connection id="source" driver="csv" url="${file}" />
    <connection id="destination" driver="$default.db.server" url="$default.db.url"
        user="$default.db.user" password="$default.db.password" />

    <query connection-id="source">
        <query connection-id="destination">
            SELECT idvalue + 1 as prioritypingroupid FROM sys_id_generator where idcolumn = 'prioritypingroup.id';
                <script connection-id="destination" if="prioritypingroupid!=null" >
                    UPDATE sys_id_generator set idvalue = ?prioritypingroupid+1 where idcolumn = 'prioritypingroup.id';

                    INSERT INTO BC_PRIORITY_PIN_GROUP(priority_pin_group_id, import_name, description, created_on, source_file)
                    values(?prioritypingroupid, '${importname}', '${description}', getdate(), '${insertfile}');

                    INSERT INTO BC_PRIORITY_PIN_MASTER(priority_pin_group_id, pin, ets, start_date, end_date, created_on)
                    values(?prioritypingroupid, '?PIN', '?ets', CONVERT(DATETIME, '?StartDate', 1), CONVERT(DATETIME, '?EndDate', 1), getdate());
                </script>
        </query>
    </query>
</etl>

JDBC provider exception: Unable to execute statement
Error statement:
INSERT INTO BC_PRIORITY_PIN_MASTER(priority_pin_group_id, pin, ets, start_date, end_date, created_on)
values(?, '?PIN', '?ets', '?StartDate', '?EndDate', getdate()). Parameters: [1]
Error codes: [S0001, 241]
Driver exception: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting date and/or time from character string.
    at scriptella.execution.EtlExecutor.execute(EtlExecutor.java:190)
    at scriptella.execution.EtlExecutor.execute(EtlExecutor.java:161)
    at com.assurewave.jsf.bean.PinProrityHandler.savePinPriorityGroup(PinProrityHandler.java:242)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)