@echo off 
rem ==PRODUCT_FILE==
del C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\PRODUCT_FILE*.* /Q /F >nul 2>nul 
sqlcmd.exe -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [import].[PRODUCT_FILE]" 
rem Nur in Quelle: CL_REPL_FACTOR;SKR51_COST_BEARER;CL_REPLACMENT_NO;PROD_CODE_SEARCH
bcp "SELECT T1.[PRODUCT_GROUP], T1.[PROD_SORT_CODE], T1.[PROD_CODE], T1.[MAKE_CD], T1.[STATE_CODE_PARTS], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[PROD_NAME], T1.[FOREIGN_NAME], T1.[TAX_CODE_1], T1.[RE_PURCHASE_PRICE], T1.[LATEST_PURCH_PRICE], T1.[AVERAGE_PRICE], T1.[PRICE_A], T1.[PRICE_B], T1.[WEIGHT], T1.[QUANTITY_DISC_CODE], T1.[CAMPAIGN_CODE], T1.[PART_GROUP], T1.[ADD_COST_CODE], T1.[REPLACING_PROD], T1.[REPLACING_MAKE_CD], T1.[REPLACE_CODE], T1.[VAT_RATE_CODE], T1.[PROD_TYPE], T1.[STATISTIC_CODE], T1.[DEDUCTABLE], T1.[DISCOUNT_TABLE], T1.[DISCOUNT_CODE], T1.[DISCOUNT_CODE1], T1.[GROSS_DISCOUNT], T1.[CALCULATION_CODE], T1.[PRICE_C], T1.[SALES_PRICE], T1.[PRICE_CHANGE_DATE], T1.[SALES_UNIT], T1.[DECIMAL_INDICATOR], T1.[SUPPLIER_CODE], T1.[PERIODICAL_INDEX], T1.[PACKAGE], T1.[PURCHASE_UNIT], T1.[PRICE_T], T1.[CUSTOM_CODE], T1.[DUTY_GROUP], T1.[COUNTRY], T1.[CURRENCY], T1.[EXRATE], T1.[COST_PERC], T1.[NEXT_LINE], T1.[CREATION_DATE], T1.[SERVICE_LEVEL], T1.[MISC_1], T1.[MISC_2], T1.[MISC_3], T1.[PRICE_D], T1.[PRICE_E], T1.[PRICE_F], T1.[PRICE_G], T1.[CAMPAIN_PRICE], T1.[PRICE_U], T1.[PRICE_V], T1.[PURCHASE_LABELS], T1.[CLAIM_RETURN_CODE], T1.[SUPPLIER_1], T1.[SUPPLIER_2], T1.[SUPPLIER_3], T1.[PURCH_DISC_CODE], T1.[PRODS_NAME_L2], T1.[PRODS_NAME_L3], T1.[DELIVERY_TIME_PR], T1.[TARIFF_NUMBER], T1.[OLD_PROD_CODE], T1.[OLD_MAKE_CD], T1.[REPL_DATE], T1.[MISC_4], T1.[MISC_5], T1.[MISC_6], T1.[FAMILY_CODE], T1.[VOL_BONUS_IND], T1.[PACKAGE_USAGE], T1.[PNC_ALLOWANCE], T1.[DESCR_LEXICON_CODE], T1.[EXCH_PART_EUROCODE], T1.[LOWEST_PURCH_PRICE], T1.[LOWEST_PU_PR_DATE], T1.[CONSIGNMENT_CODE], T1.[CATALOGUE_NO], T1.[GMPD_CD], T1.[GMPD_SUB_CD], T1.[EFFECTIVE_DATE], T1.[VALID_TIME_START], T1.[VALID_TIME_END], T1.[KEY_CUT_IDC], T1.[DISPOSAL_IDC], T1.[DISPOSAL_GRP], T1.[GUARANTEE_ACTION], T1.[DANGER_GOODS_IDC], T1.[DANGER_GOODS_CD], T1.[MAIN_WAREHOUSE_CD], T1.[ORIGINAL_COUNTRY], T1.[LENGTH], T1.[WIDTH], T1.[HEIGHT], T1.[MEASURE_UNIT], T1.[UNIT_VOLUME], T1.[DURABILITY], T1.[SALES_LIFE], T1.[PALLET_TYPE], T1.[PALLET_QTY], T1.[CARTON_TYPE], T1.[CARTON_QTY], T1.[INNERPACK_TYPE], T1.[INNERPACK_QTY], T1.[BONUS_CD], T1.[RUSH_SURCHARGE_IDC], T1.[VOR_SURCHARGE_IDC], T1.[DISCOUNT_IDC_1], T1.[DISCOUNT_IDC_2], T1.[DISCOUNT_IDC_3], T1.[DISCOUNT_IDC_4], T1.[DISCOUNT_IDC_5], T1.[DISCOUNT_IDC_6], T1.[FACTORY_REPL_CD], T1.[AVERAGE_PRICE_YEAR], T1.[DEPOSIT], T1.[LUBRICANT], T1.[STANDARD_UNIT], T1.[UNIT_CONVERSION_SALES], T1.[UNIT_CONVERSION_PURCH], T1.[OIL], T1.[EXCHANGE_PART], T1.[MAKE_CD_CORE], T1.[PROD_CODE_CORE], T1.[SKIP_PRICE_CORR], T1.[BULKY_PART], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[CHASSISNO_ON_PURCH], T1.[GM_PART_NUMBER], T1.[QUANTITY_OF_SERVICES], T1.[PRICE_FACTOR], T1.[SPECIAL_ORDER_ITEM], T1.[FUEL_EFFICIENCY_CLASS], T1.[MANUALLY_CREATED], T1.[NOISE_CLASS], T1.[NOISE_RATE], T1.[PART_DESCRIPTION_CODE], T1.[PART_DESCRIPTION_EXTRACTED], T1.[PRODUCT_TYPE], T1.[TYRE_CLASS], T1.[WEET_GRIP_CLASS], T1.[PROD_NAME_200], T1.[MIN_ORDER_QTY], T1.[MODELS], T1.[PART_RETURNABLE_FLAG], T1.[PART_SIZE_CODE], T1.[PART_STATUS_CD], T1.[PMP_CD], T1.[TECHNICAL_BLOCK], T1.[ORIGINAL_PART], T1.[SARA_PART], '1' as \"Client_DB\" FROM [deop01].[dbo].[PRODUCT_FILE] T1 " queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\PRODUCT_FILE_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\PRODUCT_FILE_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\PRODUCT_FILE_1.bcp1.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\PRODUCT_FILE_1.bcp1.log" | findstr -v "1000" 
bcp [import].[PRODUCT_FILE] in "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\PRODUCT_FILE_1.csv" -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -c -C 65001 -m 1000 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\PRODUCT_FILE_1.in.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\PRODUCT_FILE_1.bcp2.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\PRODUCT_FILE_1.bcp2.log" | findstr -v "1000"