@echo off 
rem ==VEHICLE==
del C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEHICLE*.* /Q /F >nul 2>nul 
sqlcmd.exe -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [import].[VEHICLE]" 
rem Nur in Quelle: REG_NUMBER_SEARCH
bcp "SELECT T1.[BASIS_NUMBER], T1.[STATE_CODE_CF], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[DEBIT_ACCOUNT], T1.[REGISTER_NUMBER], T1.[CHASSIS_NUMBER], T1.[CAR_GROUP], T1.[CAR_STATUS], T1.[FAC_MODEL_CODE_L], T1.[USER_CODE], T1.[OWNER_CODE], T1.[UNIT_ACCOUNTING_CF], T1.[CONTACT_PERSON], T1.[FIRST_REG_DATE], T1.[LATEST_REG_DATE], T1.[FIRST_OCCUR_DATE], T1.[EXPECTED_ARR_DATE], T1.[ARRIVAL_DATE], T1.[LAST_OWNER_CHANGE], T1.[SALESMAN_BUY], T1.[SALESMAN_SALE], T1.[MODEL_TEXT], T1.[ORIG_MODEL_CODE1], T1.[ORIG_MODEL_CODE2], T1.[COLOUR_CF], T1.[TRIM_TXT], T1.[MODEL_LINE], T1.[WORKSHOP_MODEL], T1.[FAC_MODEL_CODE_S], T1.[CLASSIFICATION], T1.[MOTOR_NUMBER], T1.[KEY_CODE], T1.[YEAR_MODEL_CF], T1.[CYLINDER_VOLUME], T1.[SEATS], T1.[DECLARATION_DATE], T1.[DECLARATION_PLACE], T1.[DECLARATION_NUMBER], T1.[ARRIVAL_SHIP], T1.[ARRIVAL_NUMBER], T1.[BILL_OF_LANDING], T1.[SCRUTINEERING_DATE], T1.[EQUIPMENT_1], T1.[EQUIPMENT_2], T1.[EQUIPMENT_3], T1.[EQUIPMENT_4], T1.[INSURANCE], T1.[INSURANCE_COMPANY], T1.[MILEAGE], T1.[MISC_1_CF], T1.[MISC_2_CF], T1.[MISC_3_CF], T1.[MISC_4_CF], T1.[MISC_5_CF], T1.[MISC_6_CF], T1.[MISC_7_CF], T1.[MISC_8_CF], T1.[MISC_9_CF], T1.[MISC_10_CF], T1.[LAST_INVOICE_DTE], T1.[CONTACT_DATE], T1.[MAIL_CODE_1], T1.[MAIL_CODE_2], T1.[MAIL_CODE_3], T1.[MAIL_CODE_4], T1.[MAIL_CODE_5], T1.[MAIL_CODE_6], T1.[MAIL_CODE_7], T1.[MAIL_CODE_8], T1.[MAIL_CODE_9], T1.[MOTOR_CODE], T1.[GEAR_CODE], T1.[DRIVE_CODE], T1.[COLOUR_CODE], T1.[TRIM_CODE], T1.[LATEST_UNIT_NO], T1.[FOLLOW_UP], T1.[NO_OF_OWNERS], T1.[CAR_LETTER], T1.[TUV_TYPE], T1.[TUV_DATE], T1.[TUV_INSP], T1.[ASU_TYPE], T1.[ASU_DATE], T1.[ASU_INSP], T1.[TYPE_YEAR], T1.[PACKAGE_CF], T1.[VEH_ASS_TYPE], T1.[SALE_THIS_YEAR], T1.[SALE_LAST_YEAR], T1.[SALE_LAST_YEAR_1], T1.[DELETE_PROPOSAL], T1.[DUPLICATE_REG_NO], T1.[LEASING], T1.[SHIP_DATE], T1.[FAC_ORDER_NUMBER], T1.[AVAILABLE], T1.[CAL_COST], T1.[CAL_COST_DATE], T1.[RUN_1], T1.[RUN_2], T1.[RUN_3], T1.[RUN_4], T1.[RUN_5], T1.[RUN_6], T1.[RUN_7], T1.[RUN_8], T1.[RUN_9], T1.[RUN_10], T1.[RUN_11], T1.[RUN_12], T1.[RUN_13], T1.[RUN_14], T1.[RUN_15], T1.[RUN_16], T1.[RUN_17], T1.[RUN_18], T1.[RUN_19], T1.[RUN_20], T1.[STOCK_DATE], T1.[MARKING_1], T1.[MARKING_2], T1.[MARKING_3], T1.[MARKING_4], T1.[MARKING_5], T1.[IMP_ORDER_NUMBER], T1.[SCRAP_DATE], T1.[TRANSMISSION_DATE], T1.[PURCH_CAL_DATE], T1.[SALES_CAL_DATE], T1.[DEALER_DEL_DATE], T1.[OPTIONAL_DATE_1], T1.[OPTIONAL_DATE_2], T1.[OPTIONAL_DATE_3], T1.[OPTIONAL_DATE_4], T1.[OPTIONAL_DATE_5], T1.[MODEL_LINE_GROUP], T1.[MODEL_TYPE_2], T1.[MAKE], T1.[HOUR_RATE_TABLE], T1.[PAID_DATE], T1.[LATEST_INV_DATE], T1.[ORIG_INV_DATE], T1.[CREDIT_NOTE_DATE], T1.[EXTRACTION_DATE], T1.[PROD_INFO], T1.[REG_NUMBER_IMP], T1.[PRICE_CARD], T1.[PURCH_AMOUNT], T1.[DEALER_NUMBER], T1.[INVOICE_STATE], T1.[VEH_DUE_DATE], T1.[DEALER_MARKING], T1.[TRADE_IN_CAR], T1.[TRADE_IN_CAR_YEAR], T1.[EXPORT_VEHICLE], T1.[DOORS], T1.[KBA_CODE], T1.[FUELTYPE], T1.[FUEL_CONS_TOWN], T1.[FUEL_CONS_90KMH], T1.[FUEL_CONS_EUNORM], T1.[CALL_FOR_SERVICE], T1.[EXP_KM_PER_YEAR], T1.[EXP_SERVICE_DATE_1], T1.[EXP_SERVICE_DATE_2], T1.[EXP_SERVICE_DATE_3], T1.[EXP_SERVICE_DATE_4], T1.[EXP_SERVICE_DATE_5], T1.[DEALER_MESSAGE_NO], T1.[SERVICE_DAYS], T1.[HOURLY_REPAIR_RATE], T1.[WORKSHOP_PRICECODE], T1.[DISCOUNT_PERC_WORK], T1.[SOLDMARK_DATE], T1.[MOBIL_SC_DATE], T1.[TYPE_CER_TXT], T1.[MAKE_CD], T1.[VEH_LOCATION], T1.[IMP_COMMENT], T1.[DEALER_NOTE], T1.[DELIVER_TO_DEALER], T1.[TRADE_IN_CAR_CHAS], T1.[GMS_REFERENCE], T1.[USE_OF_VEHICLE], T1.[PAINT_TYPE], T1.[GEAR_NO], T1.[SERV_CONTRACT_NO], T1.[PRODUCTION_NO], T1.[PHOTO], T1.[UPLOAD_MARKING], T1.[DOOR_CODE], T1.[BPM_AMOUNT], T1.[RADIO_CODE], T1.[WARRENTY_END], T1.[LAST_MOT_DATE], T1.[LAST_SERVICE_DATE], T1.[LAST_SERVICE_TXT], T1.[REPLACEMENT_DATE], T1.[NEXT_SERVICE_TXT], T1.[MAINTAIN_INT_YEARS], T1.[MAINTAIN_INT_MILES], T1.[SALES_LOCATION], T1.[SERVICE_LOCATION], T1.[FISCAL_HORSEPOWER], T1.[EXPORT_EUROCASION], T1.[HORSEPOWER], T1.[GOV_CERT_REQUEST_DATE], T1.[GOV_CERT_RECEPTION_DATE], T1.[HANDLER_SYSTEM], T1.[ENGINE_HOURS], T1.[LICENCE_LOCATION], T1.[MD_MACHINE_ID], T1.[CHASSIS_UNIQUE], T1.[COURTESY_CAR], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], '1' as \"Client_DB\" FROM [deop01].[dbo].[VEHICLE] T1 " queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEHICLE_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEHICLE_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEHICLE_1.bcp1.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEHICLE_1.bcp1.log" | findstr -v "1000" 
bcp [import].[VEHICLE] in "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEHICLE_1.csv" -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -c -C 65001 -m 1000 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEHICLE_1.in.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEHICLE_1.bcp2.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEHICLE_1.bcp2.log" | findstr -v "1000"