BCP Basic example

3- BCP Basic example 

Below example is for load multiple files into table using BCP command.
@Echo OFF

SET FILEPATH=\\unixshare\location\coreapp\env\filedrive\

@echo %DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME% - BCP IN to stage table is in progress........>%FILEPATH%\processlog.txt


BCP DBNAME.Schema.Table IN %FILEPATH%\file1.TXT -S SQLSSMSSERVER.ORACLE.net\SSMS -T -c -t"~|~" -b 100000 >>%FILEPATH%\processlog.txt
@echo %DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME% - file1 Completed and file2 is in progress........>>%FILEPATH%\processlog.txt


BCP DBNAME.Schema.Table IN %FILEPATH%\file2.TXT -S SQLSSMSSERVER.ORACLE.net\SSMS -T -c -t"~|~" -b 100000 >>%FILEPATH%\processlog.txt


@echo %DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME% - file2 Completed and file3 is in progress........>>%FILEPATH%\processlog.txt
BCP DBNAME.Schema.Table IN %FILEPATH%\file3.TXT -S SQLSSMSSERVER.ORACLE.net\SSMS -T -c -t"~|~" -b 100000 >>%FILEPATH%\processlog.txt


@echo %DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME% - file3 Completed and file4 is in progress........>>%FILEPATH%\processlog.txt
BCP DBNAME.Schema.Table IN %FILEPATH%\file4.TXT -S SQLSSMSSERVER.ORACLE.net\SSMS -T -c -t"~|~" -b 100000 >>%FILEPATH%\processlog.txt



@echo %DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME% - file4 Completed.>>%FILEPATH%\processlog.txt