C11/System/OPTIMA/SQL/batch/COMM_UNIT.bat

@echo off 
rem ==COMM_UNIT==
del C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COMM_UNIT*.* /Q /F >nul 2>nul 
sqlcmd.exe -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [import].[COMM_UNIT]" 
bcp "SELECT T1.[UNIT_NO], T1.[PERIOD], T1.[DEPARTMENT], T1.[SALESMAN], T1.[UNIT_TYPE], T1.[MODELLINE], T1.[PER_DATE], T1.[HANDLER], T1.[DATE], T1.[CALCULATE_FINAL], T1.[CALCULATE_DAY], T1.[COMM_AMOUNT_1], T1.[COMM_SW_1], T1.[COMM_AMOUNT_2], T1.[COMM_SW_2], T1.[COMM_AMOUNT_3], T1.[COMM_SW_3], T1.[COMM_AMOUNT_4], T1.[COMM_SW_4], T1.[COMM_AMOUNT_5], T1.[COMM_SW_5], T1.[COMM_AMOUNT_6], T1.[COMM_SW_6], T1.[COMM_AMOUNT_7], T1.[COMM_SW_7], T1.[COMM_AMOUNT_8], T1.[COMM_SW_8], T1.[MILEAGE], T1.[STOCK_DAYS], T1.[POINTS], T1.[ORDER_NO], T1.[SALES_PRICE], T1.[LIST_PRICE], T1.[PURCH_PRICE], T1.[BUD_PURCH_PRICE], T1.[COST], T1.[COST_PRICE_1], T1.[SALES_COST], T1.[COST_PRICE_2], T1.[MARGIN], T1.[BUD_MARGIN], T1.[OVER_PRICE], T1.[INTEREST], T1.[GEMEIN_COST], T1.[MODEL_CODE_X], T1.[DELIVERY_DAY], T1.[SOLD_TO], T1.[TOTAL_COMM], T1.[CUSTOMER_NUMBER], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[CALCULATION_TYPE], T1.[FINAL_COMM_DATE], T1.[FIXED_COMM], T1.[OWN_SALES_PRICE], T1.[USE_FIXED_COMM], T1.[COMM_OWN_SALES_PRICE], '1' as \"Client_DB\" FROM [deop01].[dbo].[COMM_UNIT] T1 " queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COMM_UNIT_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COMM_UNIT_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COMM_UNIT_1.bcp1.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COMM_UNIT_1.bcp1.log" | findstr -v "1000" 
bcp [import].[COMM_UNIT] in "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COMM_UNIT_1.csv" -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -c -C 65001 -m 1000 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COMM_UNIT_1.in.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COMM_UNIT_1.bcp2.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\COMM_UNIT_1.bcp2.log" | findstr -v "1000"