Ms Sql Extract using bcp and Load using bulk insert and bcp

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Ms Sql Extract using bcp and Load using bulk insert and bcp</name>
     <script>mssql_extract_load</script>
     <driver>com.toolsverse.etl.driver.sqlserver.MsSqlDriver</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	DATE,	
                     JOB	CHAR(8)	
                   );
               </sql>
          </task>

<task>
               <name>drop_staging_table_two</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   DROP TABLE employee_stage_two;
               </sql>
               <onexception action="ignore"/>               
          </task>

<task>
               <name>create_staging_table_two</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   create TABLE employee_stage_two
                   (
                     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	DATE,	
                     JOB	CHAR(8)	
                   );
               </sql>
          </task>

<task>
               <name>extract</name>
               <connection>source</connection>
               <class>com.toolsverse.etl.core.task.sqlserver.MsSqlExtractTask</class>
               <sql>
                   select EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,PHONENO,HIREDATE,JOB from test.dbo.employee
               </sql>
               <variables>
                   <DATA_FILENAME value="{DATA_FOLDER}emp.dat" />
                   <DELIMETER value=";" />
               </variables>
          </task>

<task>
               <name>extract_two</name>
               <connection>source</connection>
               <class>com.toolsverse.etl.core.task.sqlserver.MsSqlExtractTask</class>
               <sql>
                   select EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,PHONENO,HIREDATE,JOB from test.dbo.employee
               </sql>
               <variables>
                   <DATA_FILENAME value="{DATA_FOLDER}emp2.dat" />
                   <DELIMETER value=";" />
               </variables>
          </task>
          
           
          <task>
               <name>load</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   BULK INSERT employee_stage 
                   FROM '{DATA_FOLDER}emp.dat'                      
                   WITH 
                   ( 
                      FIELDTERMINATOR = ';', 
                      FIRSTROW = 1
                   );
               </sql>
          </task>

<task>
               <name>load_two</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.sqlserver.MsSqlLoadTask</class>
               <sql>test.dbo.employee_stage_two</sql>
               <variables>
                   <DATA_FILENAME value="{DATA_FOLDER}emp2.dat" />
                   <DELIMETER value=";" />
               </variables>
          </task>
          
          
     </tasks>
     
     <destinations>
          <destination>
               <name>employee_table</name>
               <metadata>true</metadata>
               <cursor table="employee_stage" onfinish="drop" />
          </destination>

<destination>
               <name>employee_table_two</name>
               <metadata>true</metadata>
               <cursor table="employee_stage_two" onfinish="drop" />
          </destination>
          
     </destinations>
</scenario>