@echo off 
rem ==COURTESY_CAR==
del C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COURTESY_CAR*.* /Q /F >nul 2>nul 
sqlcmd.exe -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [import].[COURTESY_CAR]" 
bcp "SELECT T1.[COURTESY_CAR_ID], T1.[DEPARTMENT], T1.[UNIT_NUMBER], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[PROGRAM], T1.[FUNCTION_CODE], T1.[CREATION_DATE], T1.[CREATION_TIME], T1.[DESCRIPTION], T1.[COURTESY_CAR_TYPE], T1.[COURTESY_VEH_TYPE], T1.[START_MILEAGE], T1.[MILEAGE], T1.[ACTIVE], T1.[CAR_LOCATION], T1.[CSY_PRICE_KM], T1.[CSY_MISC_NUMBER_KM], T1.[CSY_MAKE_CD_KM], T1.[CSY_PRICE_1], T1.[CSY_INCLUDED_KM_1], T1.[CSY_MISC_NUMBER_1], T1.[CSY_MAKE_CD_1], T1.[CSY_PRICE_2], T1.[CSY_INCLUDED_KM_2], T1.[CSY_MISC_NUMBER_2], T1.[CSY_MAKE_CD_2], T1.[CSY_PRICE_3], T1.[CSY_INCLUDED_KM_3], T1.[CSY_MISC_NUMBER_3], T1.[CSY_MAKE_CD_3], T1.[CSY_PRICE_4], T1.[CSY_INCLUDED_KM_4], T1.[CSY_MISC_NUMBER_4], T1.[CSY_MAKE_CD_4], T1.[CSY_PRICE_I], T1.[CSY_MISC_NUMBER_I], T1.[CSY_MAKE_CD_I], T1.[CSY_PRICE_CW], T1.[CSY_MISC_NUMBER_CW], T1.[CSY_MAKE_CD_CW], T1.[CSY_PRICE_F], T1.[CSY_MISC_NUMBER_F], T1.[CSY_MAKE_CD_F], T1.[FUELTYPE], T1.[CSY_PRICE_C], T1.[CSY_PRICE_KM_2], T1.[START_DATE], T1.[END_DATE], T1.[REGISTER_NUMBER], T1.[WORKSHOP_MODEL], T1.[MODEL_TEXT], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], '1' as \"Client_DB\" FROM [deop01].[dbo].[COURTESY_CAR] T1 " queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COURTESY_CAR_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COURTESY_CAR_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COURTESY_CAR_1.bcp1.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COURTESY_CAR_1.bcp1.log" | findstr -v "1000" 
bcp [import].[COURTESY_CAR] in "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COURTESY_CAR_1.csv" -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -c -C 65001 -m 1000 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COURTESY_CAR_1.in.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COURTESY_CAR_1.bcp2.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COURTESY_CAR_1.bcp2.log" | findstr -v "1000"