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

@echo off 
rem ==CUSTOMER==
del C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER*.* /Q /F >nul 2>nul 
sqlcmd.exe -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [import].[CUSTOMER]" 
rem Nur in Quelle: ELEC_INVOICE_FORM_VEH;DIGITAL_SIGNATURE;INVOICE_EXPORT_TYPE;ADVERTISING_PROTECTION;PREFERRED_CHANNEL_2;PSA_RRDI_CODE;DUP_STATUS;FORGOTTEN;PUBLIC_ID_NUMBER;PREFERREDPHONE;ADDITIONAL_PDF_ELEC_INV;DUP_MAIN_CUSTOMER_NUMBER
bcp "SELECT T1.[CUSTOMER_NUMBER], T1.[STATE_CODE_CUST], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[CUST_ALT_KEY], T1.[NAME], T1.[STREET_ADDR], T1.[ADDR_2], T1.[MAIL_ADDR], T1.[ZIPCODE], T1.[DEBIT_CUSTOMER], T1.[TITLE_CODE], T1.[TITLE], T1.[PMT_TERM], T1.[INVOICE_COPY_CODE], T1.[DELIVERY_WAY_CODE], T1.[SMALL_ACCESSORIES], T1.[SMALL_INV_CHARGE], T1.[WORKSHOP_PRICECODE], T1.[VAT_REGNO], T1.[SALESMAN], T1.[GROSS_DISCOUNT], T1.[DELIVERY_STOP_CODE], T1.[CREDIT_LIMIT], T1.[REMINDER_CODE], T1.[ACCOUNT_TYPE_CU], T1.[ACCOUNT_PRINT], T1.[BANK_NAME], T1.[BANK_REG_NO], T1.[BANK_ACCOUNT_NO], T1.[PAYMENT_WAY], T1.[PRICE_CODE], T1.[DISCOUNT_PERC_WORK], T1.[DISCOUNT_LIMIT], T1.[ANNUAL_DISC_PERC], T1.[ANNUAL_DISC_AMOUNT], T1.[ANNUAL_DISC_CODE], T1.[ADVERT_DISC_PERC], T1.[ADVERT_DISC_AMOUNT], T1.[INTERNAL_CODE_CUST], T1.[CUSTOMER_GROUP], T1.[CUSTOMER_PROSPECT], T1.[TAX_CODE], T1.[FLEET_OWNER], T1.[CONTACT_PERSON], T1.[PHONE_1], T1.[PHONE_2], T1.[COMMENT_1], T1.[COMMENT_2], 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.[LAST_INVOICE_DATE], T1.[PROFIT_C_U], T1.[DEBITED_MM_CUST], T1.[DEBITED_TY_CUST], T1.[DEBITED_PRYE_CUST], T1.[DISCOUNT_MM_CUST], T1.[DISCOUNT_TY_CUST], T1.[DISCOUNT_PY_CUST], T1.[MARG_MM_CUST], T1.[MARG_TY_CUST], T1.[MARG_PY_CUST], T1.[SALDO_C_U_CUST], T1.[LAST_PMT_DTE_CUST], T1.[PMT_TIME_CUST], T1.[INTERESTS], T1.[SALDO_LAST_ST], T1.[AOS_DEAL_NUMBER], T1.[CPR_NUMBER], T1.[DELETE_PROPOSAL], T1.[CREATION_DATE], T1.[CREATER], T1.[REDUCTION_CODE], T1.[START_NO], T1.[LAST_NO], T1.[LATEST_PERIOD], T1.[REMINDER_GROUP], T1.[REMINDER_DATE], T1.[PMT_TERMCODE_2], T1.[BACK_ORDER_DELIV], T1.[COUNTRY_CODE_CU], T1.[INSTALMENT_CODE], T1.[FOLLOW_UP_CU], T1.[VAT_TABLE_WORK], T1.[VAT_TABLE_NORMAL], T1.[VAT_TABLE], T1.[OCCUPATION_CODE], T1.[TELEFAX_NUMBER], T1.[LANGUAGE_CODE], T1.[BIRTHDAY], T1.[BIRTHDAY2], T1.[ADDR_3], T1.[COUNTY], T1.[MAX_BOOKING_DAYS], T1.[DEPARTMENT_5], T1.[RIB_KEY], T1.[PRICE_A_G], T1.[REQ_NO_COMPULSORY], T1.[VAT_REGNO_EU], T1.[WORKSHOP_SALESMAN], T1.[HOURLY_REPAIR_RATE], T1.[ELEC_INVOICE], T1.[ELEC_DEL_NOTE], T1.[ELEC_ORDER_CONF], T1.[ELEC_INVOICE_FORM], T1.[ELEC_COLL_INV_FORM], T1.[ELEC_DEL_NOTE_FORM], T1.[ELEC_ORD_CONF_FORM], T1.[ONLY_COLL_INVOICE], T1.[CUST_COMPANY_NO], T1.[DEALER_NUMBER], T1.[MOBILE_PHONE], T1.[MOBILE_PHONE_2], T1.[E_MAIL_ADDRESS], T1.[E_MAIL_ADDRESS_2], T1.[BRANCH], T1.[DECLARATION_STATE], T1.[USE_WORK_TYPE_CODE], T1.[FLEET_ID_NUMBER], T1.[FIRST_NAME], T1.[LAST_NAME], T1.[GENDER], T1.[COMPANY], T1.[MAIL_SUPPRESS], T1.[PO_BOX_15], T1.[PO_BOX_ZIPCODE], T1.[PO_BOX_TOWN], T1.[WEB_ADDRESS], T1.[FAMILY_STATUS], T1.[CHILDREN], T1.[HOBBY], T1.[EXT_CUSTOMER_GROUP], T1.[MEMBERSHIP_NUMBER], T1.[TRADE_REGISTER], T1.[PDF_INVOICE], T1.[E_COMMERCE_VEH], T1.[E_MAIL_ADDRESS_3], T1.[SEND_ORDER_ADVICE], T1.[SALES_LOCATION], T1.[SERVICE_LOCATION], T1.[STREET_NUMBER], T1.[STREET_NUMBER_EXT], T1.[STREET_NUMBER_EXT2], T1.[MAIL_ADDR_2], T1.[COUNTY_2], T1.[EXTERNAL_ID], T1.[LICENSE_NUMBER], T1.[STREET_NUMBER_2], T1.[V5_CUSTOMER_TYPE], T1.[ZIPCODE_2], T1.[DECL_STATE_DATE], T1.[ORDER_LIMIT], T1.[ADDR_2_2], T1.[ADDR_3_2], T1.[INTERNAL_TRANSFER], T1.[COLLECT_INV_FREQUENCY], T1.[VAT_SUSPENSION], T1.[CUSTOMER_GROUP_VEH], T1.[RENAULT_DEALER_NUMBER], T1.[RENAULT_TRANS_METHOD], T1.[BIRTH_PLACE], T1.[BIRTH_TOWN_CODE], T1.[COMPANY_ACRONYM_CODE], T1.[REGISTERED_OFFICE], T1.[INCOME_TAX_CODE], T1.[HOBBY_CODE], T1.[AGENT_CODE], T1.[BANK_BRANCH_REG_NO], T1.[INVOICE_FORM_CODE_NON_ELEC], T1.[FREIGHT_PER_DAY], T1.[PDF_STATEMENT], T1.[PDF_FORMCODE], T1.[E_MAIL_ADDRESS_4], T1.[IN_HOUSE_FINANCING], T1.[INSURANCE_CODE], T1.[HANDLER_SYSTEM], T1.[LOCATION_CODE], T1.[SKIP_CUST_DATA_CHECKS], T1.[OBSOLETE], T1.[FREIGHT_FEE_GROUP], T1.[CASH_MARK], T1.[SEND_ORDER_FOLLOW_UP], T1.[VEH_CERTIFICATE_PRINT_IMP], T1.[DECL_FIRST_CHANGE_DATE], T1.[DECL_LAST_CUST_CONT_DATE], T1.[DECL_LAST_CHANGE_ORDER_NO], T1.[DECL_STATE_ORIGIN], T1.[DECL_STATE_REMARK], T1.[PDF_INTEREST_INVOICE], T1.[PDF_FORMCODE_II], T1.[E_MAIL_ADDRESS_5], T1.[PDF_CLAIM_INVOICE], T1.[PDF_FORMCODE_CI], T1.[E_MAIL_ADDRESS_6], T1.[BIC], T1.[IBAN], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[PMT_CODE_VEHICLE], T1.[BYPASS_AUTO_SEARCH], T1.[E_MAIL_ADDRESS_7], T1.[IDENTITY_CARD], T1.[SMALL_ACCESS_SEPARATE], T1.[E_MAIL_ADDRESS_8], T1.[PDF_FORMCODE_RL], T1.[PDF_REMINDER_LETTER], T1.[DECL_FORM_PRESENTED], T1.[E_MAIL_ADDRESS_10], T1.[E_MAIL_ADDRESS_9], T1.[FORD_PAYMENT_CARD], T1.[PDF_FORMCODE_L1], T1.[PDF_FORMCODE_L2], T1.[PDF_LEASING_INVOICE], T1.[PDF_SERVICE_INVOICE], T1.[SHOW_TIME_PRICE], T1.[CENTRAL_CUSTOMER_FILE], T1.[CONTACT_FIRST_NAME], T1.[CONTACT_LAST_NAME], T1.[CONTACT_TITLE], T1.[CONTACT_TITLE_CODE], T1.[E_MAIL_ADDRESS_11], T1.[MOBILE_PHONE_3], T1.[PDF_FORMCODE_SC], T1.[PDF_SEPA_NOTIFICATION], T1.[PDF_SERVICE_CONTRACT], T1.[PREFERRED_CHANNEL], T1.[PREFERRED_SMART_PAY], T1.[RENAULT_BRANCH], '1' as \"Client_DB\" FROM [deop01].[dbo].[CUSTOMER] T1 " queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_1.bcp1.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_1.bcp1.log" | findstr -v "1000" 
bcp [import].[CUSTOMER] in "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_1.csv" -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -c -C 65001 -m 1000 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_1.in.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_1.bcp2.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_1.bcp2.log" | findstr -v "1000"