Ms Sql Extract using bcp and Load using bulk insert and bcp
Ms Sql Extract using bcp and Load using bulk insert and bcp
com.toolsverse.etl.driver.sqlserver.MsSqlDriver
EXTRACT_LOAD
drop_staging_table
dest
com.toolsverse.etl.core.task.common.SqlTask
DROP TABLE employee_stage;
create_staging_table
dest
com.toolsverse.etl.core.task.common.SqlTask
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) );
drop_staging_table_two
dest
com.toolsverse.etl.core.task.common.SqlTask
DROP TABLE employee_stage_two;
create_staging_table_two
dest
com.toolsverse.etl.core.task.common.SqlTask
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) );
extract
source
com.toolsverse.etl.core.task.sqlserver.MsSqlExtractTask
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,PHONENO,HIREDATE,JOB from test.dbo.employee
extract_two
source
com.toolsverse.etl.core.task.sqlserver.MsSqlExtractTask
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,PHONENO,HIREDATE,JOB from test.dbo.employee
load
dest
com.toolsverse.etl.core.task.common.SqlTask
BULK INSERT employee_stage FROM '{DATA_FOLDER}emp.dat' WITH ( FIELDTERMINATOR = ';', FIRSTROW = 1 );
load_two
dest
com.toolsverse.etl.core.task.sqlserver.MsSqlLoadTask
test.dbo.employee_stage_two
employee_table
true
employee_table_two
true