Sybase Extract and load using bcp

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Sybase Extract and load using bcp</name>
     <script>sybase_extract_load</script>
     <driver>com.toolsverse.etl.driver.sqlserver.SybaseDriver</driver>
     <allow>EXTRACT_LOAD</allow>
     <tasks>
          
          <task>
               <name>drop_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   DROP TABLE employee_stage;
               </sql>
               <onexception action="ignore"/>               
          </task>

<task>
               <name>create_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                 CREATE TABLE employee_stage
                 (
                   EMPNO char(6) NOT NULL,
                   FIRSTNME varchar(12) NOT NULL,
                   MIDINIT char(1),
                   LASTNAME varchar(15) NOT NULL,
                   WORKDEPT char(3),
                   PHONENO char(4),
                   HIREDATE datetime,
                   JOB char(8),
                   EDLEVEL smallint NOT NULL,
                   SEX char(1),
                   BIRTHDATE datetime,
                   SALARY numeric(9,2),
                   BONUS numeric(9,2),
                   COMM numeric(9,2)
                  )               
               </sql>
          </task>

<task>
               <name>extract</name>
               <connection>source</connection>
               <driver>com.toolsverse.etl.driver.sqlserver.SybaseDriver</driver>

<class>com.toolsverse.etl.core.task.sqlserver.SybaseExtractTask</class>
               
               <sql>
                   test.dbo.EMPLOYEE
               </sql>
               <variables>
                   <DATA_FILENAME value="{DATA_FOLDER}emp.dat" />
                   <DELIMETER value=";" />
               </variables>
          </task>

<task>
               <name>load</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.sqlserver.SybaseLoadTask</class>
               <driver>com.toolsverse.etl.driver.sqlserver.SybaseDriver</driver>

<sql>test.dbo.employee_stage</sql>
               <variables>
                   <DATA_FILENAME value="{DATA_FOLDER}emp.dat" />
                   <DELIMETER value=";" />
               </variables>
          </task>
          
          
     </tasks>
     
     <destinations>
          <destination>
               <name>employee_table</name>
               <metadata>true</metadata>
               <cursor table="employee_stage" onfinish="drop" />
          </destination>
     </destinations>
</scenario>