BCP-Basic Part 2

7- BCP Basic example Part 2 

@echo off

@echo dDate = 2010-10-01  > %FILEPATH%\lOGFILE.txt

SET FILEPATH=\\folder1\folder2\folder3\
@echo %DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME% > %FILEPATH%\lOGFILE.txt
@echo %DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME% - BCP Job Starting... !  >> \%FILEPATH%\lOGFILE.txt
BCP "SELECT * FROM TABLE WHERE DATE='2020-05-31'" queryout %FILEPATH%\FileOutput.txt -S SSMS_ORACLE_SQLSERVER -T -c
@echo %DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME% - BCP OUT  for FileOutput COMPLETED !  >> %FILEPATH%\lOGFILE.txt
BCP LOBInbound.BlueStem.TABLE in %FILEPATH%\FileOutput.txt -S SSMS_ORACLE_SQLSERVER -T -c
@echo %DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME% - BCP IN   for FileOutput COMPLETED !  >> %FILEPATH%\lOGFILE.txt
del %FILEPATH%\FileOutput.txt
@echo %DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME% - File deleted  for FileOutput COMPLETED ! %FILEPATH%\lOGFILE.txt