Python-Projekte/autoline.bat

@echo off
cd /d %~dp0
set PYTHON="C:\dev\Python\Python38-32"
rem Ziel-Tabelle 'crmactivitycomment' existiert nicht!
rem Ziel-Tabelle 'crmcustomer' existiert nicht!
rem Ziel-Tabelle 'crmcustomer' existiert nicht!
rem Ziel-Tabelle 'crmcustomer' existiert nicht!
rem Ziel-Tabelle 'vhcwipheader' existiert nicht!
rem Ziel-Tabelle 'vhcwipheader' existiert nicht!
rem Ziel-Tabelle 'vhcwipheader' existiert nicht!
echo ==account==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[account]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Account_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"]]" 
bcp.exe [temp].[account] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Account_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Account_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[account] T1 INNER JOIN [temp].[account] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FAC_AccountNumber] = T2.[FAC_AccountNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[account] SELECT * FROM [temp].[account]" 

echo ==account==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[account]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Account_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"]]" 
bcp.exe [temp].[account] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Account_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Account_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[account] T1 INNER JOIN [temp].[account] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FAC_AccountNumber] = T2.[FAC_AccountNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[account] SELECT * FROM [temp].[account]" 

echo ==account==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[account]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Account_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"]]" 
bcp.exe [temp].[account] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Account_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Account_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[account] T1 INNER JOIN [temp].[account] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FAC_AccountNumber] = T2.[FAC_AccountNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[account] SELECT * FROM [temp].[account]" 

echo ==account==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[account]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Account_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"]]" 
bcp.exe [temp].[account] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Account_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Account_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[account] T1 INNER JOIN [temp].[account] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FAC_AccountNumber] = T2.[FAC_AccountNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[account] SELECT * FROM [temp].[account]" 

echo ==activity==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[activity]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Activity_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[activity] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Activity_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Activity_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[activity] T1 INNER JOIN [temp].[activity] T2 ON T1.[Activity_BKActivityID] = T2.[Activity_BKActivityID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[activity] SELECT * FROM [temp].[activity]" 

echo ==activity==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[activity]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Activity_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[activity] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Activity_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Activity_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[activity] T1 INNER JOIN [temp].[activity] T2 ON T1.[Activity_BKActivityID] = T2.[Activity_BKActivityID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[activity] SELECT * FROM [temp].[activity]" 

echo ==activity==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[activity]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Activity_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[activity] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Activity_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Activity_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[activity] T1 INNER JOIN [temp].[activity] T2 ON T1.[Activity_BKActivityID] = T2.[Activity_BKActivityID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[activity] SELECT * FROM [temp].[activity]" 

echo ==activity==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[activity]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Activity_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[activity] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Activity_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Activity_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[activity] T1 INNER JOIN [temp].[activity] T2 ON T1.[Activity_BKActivityID] = T2.[Activity_BKActivityID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[activity] SELECT * FROM [temp].[activity]" 

echo ==color==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[color]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Color_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[color] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Color_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Color_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[color] T1 INNER JOIN [temp].[color] T2 ON T1.[Color_BKColorID] = T2.[Color_BKColorID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[color] SELECT * FROM [temp].[color]" 

echo ==color==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[color]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Color_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[color] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Color_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Color_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[color] T1 INNER JOIN [temp].[color] T2 ON T1.[Color_BKColorID] = T2.[Color_BKColorID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[color] SELECT * FROM [temp].[color]" 

echo ==color==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[color]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Color_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[color] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Color_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Color_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[color] T1 INNER JOIN [temp].[color] T2 ON T1.[Color_BKColorID] = T2.[Color_BKColorID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[color] SELECT * FROM [temp].[color]" 

echo ==color==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[color]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Color_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[color] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Color_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Color_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[color] T1 INNER JOIN [temp].[color] T2 ON T1.[Color_BKColorID] = T2.[Color_BKColorID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[color] SELECT * FROM [temp].[color]" 

echo ==costcentre==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[costcentre]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CostCentre_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[costcentre] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CostCentre_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CostCentre_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[costcentre] T1 INNER JOIN [temp].[costcentre] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FCC_BKCostCentre] = T2.[FCC_BKCostCentre]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[costcentre] SELECT * FROM [temp].[costcentre]" 

echo ==costcentre==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[costcentre]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CostCentre_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[costcentre] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CostCentre_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CostCentre_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[costcentre] T1 INNER JOIN [temp].[costcentre] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FCC_BKCostCentre] = T2.[FCC_BKCostCentre]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[costcentre] SELECT * FROM [temp].[costcentre]" 

echo ==costcentre==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[costcentre]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CostCentre_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[costcentre] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CostCentre_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CostCentre_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[costcentre] T1 INNER JOIN [temp].[costcentre] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FCC_BKCostCentre] = T2.[FCC_BKCostCentre]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[costcentre] SELECT * FROM [temp].[costcentre]" 

echo ==costcentre==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[costcentre]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CostCentre_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[costcentre] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CostCentre_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CostCentre_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[costcentre] T1 INNER JOIN [temp].[costcentre] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FCC_BKCostCentre] = T2.[FCC_BKCostCentre]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[costcentre] SELECT * FROM [temp].[costcentre]" 

echo ==crmactivitytype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[crmactivitytype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CRMActivityType_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[crmactivitytype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMActivityType_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMActivityType_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[crmactivitytype] T1 INNER JOIN [temp].[crmactivitytype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[CRMActivType_BKCRMActivityTypeID] = T2.[CRMActivType_BKCRMActivityTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[crmactivitytype] SELECT * FROM [temp].[crmactivitytype]" 

echo ==crmactivitytype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[crmactivitytype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CRMActivityType_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[crmactivitytype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMActivityType_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMActivityType_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[crmactivitytype] T1 INNER JOIN [temp].[crmactivitytype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[CRMActivType_BKCRMActivityTypeID] = T2.[CRMActivType_BKCRMActivityTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[crmactivitytype] SELECT * FROM [temp].[crmactivitytype]" 

echo ==crmactivitytype==
rem Nur in Ziel:   CRMActivType_CRMActivityGroupCode;CRMActivType_CRMActivityGroupDescription
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[crmactivitytype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CRMActivityType_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[crmactivitytype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMActivityType_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMActivityType_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[crmactivitytype] T1 INNER JOIN [temp].[crmactivitytype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[CRMActivType_BKCRMActivityTypeID] = T2.[CRMActivType_BKCRMActivityTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[crmactivitytype] SELECT * FROM [temp].[crmactivitytype]" 

echo ==crmactivitytype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[crmactivitytype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CRMActivityType_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[crmactivitytype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMActivityType_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMActivityType_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[crmactivitytype] T1 INNER JOIN [temp].[crmactivitytype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[CRMActivType_BKCRMActivityTypeID] = T2.[CRMActivType_BKCRMActivityTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[crmactivitytype] SELECT * FROM [temp].[crmactivitytype]" 

echo ==crmactivity==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[crmactivity]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CRMActivity_106.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"]]" 
bcp.exe [temp].[crmactivity] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMActivity_106.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMActivity_106.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[crmactivity] T1 INNER JOIN [temp].[crmactivity] T2 ON T1.[COMP] = T2.[COMP] AND T1.[CRMActivity_CRMActivityID] = T2.[CRMActivity_CRMActivityID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[crmactivity] SELECT * FROM [temp].[crmactivity]" 

echo ==crmvehicle==
rem C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CRMVehicle_106.csv fehlerhaft!
echo ==crmvehicle==
rem Nur in Ziel:   Vehicle_LiveStatus;Vehicle_EngineSize;Vehicle_VehicleWarrantyExpiryDate;Vehicle_VehicleModelGroupCode;Vehicle_CompanyVehicle
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[crmvehicle]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CRMVehicle_206.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"object\"], [41, \"object\"], [42, \"object\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"], [64, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[crmvehicle] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMVehicle_206.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMVehicle_206.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[crmvehicle] SELECT * FROM [temp].[crmvehicle]" 

echo ==crmvehicle==
rem Nur in Ziel:   Vehicle_LiveStatus;Vehicle_EngineSize;Vehicle_VehicleWarrantyExpiryDate;Vehicle_VehicleModelGroupCode;Vehicle_CompanyVehicle;Vehicle_GovermentNumber;Vehicle_BuyingLocation;Vehicle_VehicleModelDescription
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[crmvehicle]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CRMVehicle_306.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"object\"], [41, \"object\"], [42, \"object\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[crmvehicle] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMVehicle_306.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMVehicle_306.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[crmvehicle] SELECT * FROM [temp].[crmvehicle]" 

echo ==customergroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[customergroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CustomerGroup_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[customergroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CustomerGroup_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CustomerGroup_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[customergroup] T1 INNER JOIN [temp].[customergroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FCG_CustomerGroup] = T2.[FCG_CustomerGroup]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[customergroup] SELECT * FROM [temp].[customergroup]" 

echo ==customergroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[customergroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CustomerGroup_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[customergroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CustomerGroup_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CustomerGroup_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[customergroup] T1 INNER JOIN [temp].[customergroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FCG_CustomerGroup] = T2.[FCG_CustomerGroup]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[customergroup] SELECT * FROM [temp].[customergroup]" 

echo ==customergroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[customergroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CustomerGroup_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[customergroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CustomerGroup_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CustomerGroup_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[customergroup] T1 INNER JOIN [temp].[customergroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FCG_CustomerGroup] = T2.[FCG_CustomerGroup]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[customergroup] SELECT * FROM [temp].[customergroup]" 

echo ==customergroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[customergroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\CustomerGroup_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[customergroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CustomerGroup_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CustomerGroup_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[customergroup] T1 INNER JOIN [temp].[customergroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FCG_CustomerGroup] = T2.[FCG_CustomerGroup]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[customergroup] SELECT * FROM [temp].[customergroup]" 

echo ==customer==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[customer]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Customer_106.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"object\"], [41, \"object\"], [42, \"object\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"], [64, \"object\"], [65, \"object\"]]" 
bcp.exe [temp].[customer] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Customer_106.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Customer_106.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[customer] T1 INNER JOIN [temp].[customer] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Cust_BKCustomerID] = T2.[Cust_BKCustomerID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[customer] SELECT * FROM [temp].[customer]" 

echo ==customer==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[customer]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Customer_206.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"object\"], [41, \"object\"], [42, \"object\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"], [64, \"object\"], [65, \"object\"]]" 
bcp.exe [temp].[customer] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Customer_206.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Customer_206.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[customer] T1 INNER JOIN [temp].[customer] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Cust_BKCustomerID] = T2.[Cust_BKCustomerID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[customer] SELECT * FROM [temp].[customer]" 

echo ==customer==
rem Nur in Ziel:   Cust_DoNotContact;Cust_FirstName;Cust_Title;Cust_TPSONEmail;Cust_CustomerStatus;Cust_LastName;Cust_MarkedForDeletion
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[customer]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Customer_305.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"object\"], [41, \"object\"], [42, \"object\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[customer] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Customer_305.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Customer_305.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[customer] T1 INNER JOIN [temp].[customer] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Cust_BKCustomerID] = T2.[Cust_BKCustomerID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[customer] SELECT * FROM [temp].[customer]" 

echo ==customer==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[customer]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Customer_406.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"object\"], [41, \"object\"], [42, \"object\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"], [64, \"object\"], [65, \"object\"]]" 
bcp.exe [temp].[customer] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Customer_406.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Customer_406.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[customer] T1 INNER JOIN [temp].[customer] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Cust_BKCustomerID] = T2.[Cust_BKCustomerID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[customer] SELECT * FROM [temp].[customer]" 

echo ==departmenttypecode==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[departmenttypecode]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\DepartmentTypeCode_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[departmenttypecode] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\DepartmentTypeCode_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\DepartmentTypeCode_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[departmenttypecode] T1 INNER JOIN [temp].[departmenttypecode] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Department_DepartmentId] = T2.[Department_DepartmentId] AND T1.[Department_DepartmentTypeCode] = T2.[Department_DepartmentTypeCode]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[departmenttypecode] SELECT * FROM [temp].[departmenttypecode]" 

echo ==departmenttypecode==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[departmenttypecode]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\DepartmentTypeCode_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[departmenttypecode] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\DepartmentTypeCode_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\DepartmentTypeCode_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[departmenttypecode] T1 INNER JOIN [temp].[departmenttypecode] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Department_DepartmentId] = T2.[Department_DepartmentId] AND T1.[Department_DepartmentTypeCode] = T2.[Department_DepartmentTypeCode]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[departmenttypecode] SELECT * FROM [temp].[departmenttypecode]" 

echo ==departmenttypecode==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[departmenttypecode]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\DepartmentTypeCode_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[departmenttypecode] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\DepartmentTypeCode_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\DepartmentTypeCode_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[departmenttypecode] T1 INNER JOIN [temp].[departmenttypecode] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Department_DepartmentId] = T2.[Department_DepartmentId] AND T1.[Department_DepartmentTypeCode] = T2.[Department_DepartmentTypeCode]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[departmenttypecode] SELECT * FROM [temp].[departmenttypecode]" 

echo ==departmenttypecode==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[departmenttypecode]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\DepartmentTypeCode_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[departmenttypecode] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\DepartmentTypeCode_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\DepartmentTypeCode_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[departmenttypecode] T1 INNER JOIN [temp].[departmenttypecode] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Department_DepartmentId] = T2.[Department_DepartmentId] AND T1.[Department_DepartmentTypeCode] = T2.[Department_DepartmentTypeCode]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[departmenttypecode] SELECT * FROM [temp].[departmenttypecode]" 

echo ==employee==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[employee]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Employee_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"]]" 
bcp.exe [temp].[employee] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Employee_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Employee_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[employee] T1 INNER JOIN [temp].[employee] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Emp_BKEmployeeID] = T2.[Emp_BKEmployeeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[employee] SELECT * FROM [temp].[employee]" 

echo ==employee==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[employee]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Employee_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"]]" 
bcp.exe [temp].[employee] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Employee_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Employee_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[employee] T1 INNER JOIN [temp].[employee] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Emp_BKEmployeeID] = T2.[Emp_BKEmployeeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[employee] SELECT * FROM [temp].[employee]" 

echo ==employee==
rem Nur in Ziel:   Emp_AnalysisCode
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[employee]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Employee_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[employee] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Employee_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Employee_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[employee] T1 INNER JOIN [temp].[employee] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Emp_BKEmployeeID] = T2.[Emp_BKEmployeeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[employee] SELECT * FROM [temp].[employee]" 

echo ==employee==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[employee]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Employee_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"]]" 
bcp.exe [temp].[employee] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Employee_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Employee_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[employee] T1 INNER JOIN [temp].[employee] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Emp_BKEmployeeID] = T2.[Emp_BKEmployeeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[employee] SELECT * FROM [temp].[employee]" 

echo ==financetransaction==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[financetransaction]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\FinanceTransaction_106.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"]]" 
bcp.exe [temp].[financetransaction] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\FinanceTransaction_106.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\FinanceTransaction_106.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[financetransaction] T1 INNER JOIN [temp].[financetransaction] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Ftrans_UniqueID] = T2.[Ftrans_UniqueID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[financetransaction] SELECT * FROM [temp].[financetransaction]" 

echo ==financetransaction==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[financetransaction]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\FinanceTransaction_206.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"]]" 
bcp.exe [temp].[financetransaction] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\FinanceTransaction_206.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\FinanceTransaction_206.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[financetransaction] T1 INNER JOIN [temp].[financetransaction] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Ftrans_UniqueID] = T2.[Ftrans_UniqueID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[financetransaction] SELECT * FROM [temp].[financetransaction]" 

echo ==financetransaction==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[financetransaction]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\FinanceTransaction_305.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"]]" 
bcp.exe [temp].[financetransaction] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\FinanceTransaction_305.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\FinanceTransaction_305.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[financetransaction] T1 INNER JOIN [temp].[financetransaction] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Ftrans_UniqueID] = T2.[Ftrans_UniqueID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[financetransaction] SELECT * FROM [temp].[financetransaction]" 

echo ==financetransaction==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[financetransaction]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\FinanceTransaction_406.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"]]" 
bcp.exe [temp].[financetransaction] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\FinanceTransaction_406.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\FinanceTransaction_406.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[financetransaction] T1 INNER JOIN [temp].[financetransaction] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Ftrans_UniqueID] = T2.[Ftrans_UniqueID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[financetransaction] SELECT * FROM [temp].[financetransaction]" 

echo ==labourcalendar==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[labourcalendar]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\LabourCalendar_105.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"]]" 
bcp.exe [temp].[labourcalendar] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\LabourCalendar_105.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\LabourCalendar_105.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[labourcalendar] T1 INNER JOIN [temp].[labourcalendar] T2 ON T1.[COMP] = T2.[COMP] AND T1.[WL calnd_Day] = T2.[WL calnd_Day] AND T1.[WL calnd_Resource] = T2.[WL calnd_Resource] AND T1.[WL calnd_StTime] = T2.[WL calnd_StTime]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[labourcalendar] SELECT * FROM [temp].[labourcalendar]" 

echo ==labourcalendar==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[labourcalendar]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\LabourCalendar_205.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"]]" 
bcp.exe [temp].[labourcalendar] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\LabourCalendar_205.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\LabourCalendar_205.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[labourcalendar] T1 INNER JOIN [temp].[labourcalendar] T2 ON T1.[COMP] = T2.[COMP] AND T1.[WL calnd_Day] = T2.[WL calnd_Day] AND T1.[WL calnd_Resource] = T2.[WL calnd_Resource] AND T1.[WL calnd_StTime] = T2.[WL calnd_StTime]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[labourcalendar] SELECT * FROM [temp].[labourcalendar]" 

echo ==labourcalendar==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[labourcalendar]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\LabourCalendar_305.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"]]" 
bcp.exe [temp].[labourcalendar] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\LabourCalendar_305.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\LabourCalendar_305.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[labourcalendar] T1 INNER JOIN [temp].[labourcalendar] T2 ON T1.[COMP] = T2.[COMP] AND T1.[WL calnd_Day] = T2.[WL calnd_Day] AND T1.[WL calnd_Resource] = T2.[WL calnd_Resource] AND T1.[WL calnd_StTime] = T2.[WL calnd_StTime]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[labourcalendar] SELECT * FROM [temp].[labourcalendar]" 

echo ==labourcalendar==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[labourcalendar]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\LabourCalendar_405.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"]]" 
bcp.exe [temp].[labourcalendar] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\LabourCalendar_405.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\LabourCalendar_405.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[labourcalendar] T1 INNER JOIN [temp].[labourcalendar] T2 ON T1.[COMP] = T2.[COMP] AND T1.[WL calnd_Day] = T2.[WL calnd_Day] AND T1.[WL calnd_Resource] = T2.[WL calnd_Resource] AND T1.[WL calnd_StTime] = T2.[WL calnd_StTime]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[labourcalendar] SELECT * FROM [temp].[labourcalendar]" 

echo ==labour==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[labour]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Labour_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[labour] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Labour_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Labour_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[labour] T1 INNER JOIN [temp].[labour] T2 ON T1.[BKDMSLabourTypeID] = T2.[BKDMSLabourTypeID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[labour] SELECT * FROM [temp].[labour]" 

echo ==labour==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[labour]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Labour_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[labour] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Labour_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Labour_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[labour] T1 INNER JOIN [temp].[labour] T2 ON T1.[BKDMSLabourTypeID] = T2.[BKDMSLabourTypeID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[labour] SELECT * FROM [temp].[labour]" 

echo ==labour==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[labour]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Labour_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[labour] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Labour_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Labour_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[labour] T1 INNER JOIN [temp].[labour] T2 ON T1.[BKDMSLabourTypeID] = T2.[BKDMSLabourTypeID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[labour] SELECT * FROM [temp].[labour]" 

echo ==labour==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[labour]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Labour_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[labour] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Labour_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Labour_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[labour] T1 INNER JOIN [temp].[labour] T2 ON T1.[BKDMSLabourTypeID] = T2.[BKDMSLabourTypeID] AND T1.[COMP] = T2.[COMP]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[labour] SELECT * FROM [temp].[labour]" 

echo ==make==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[make]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Make_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"]]" 
bcp.exe [temp].[make] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Make_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Make_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[make] T1 INNER JOIN [temp].[make] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FM_Description] = T2.[FM_Description] AND T1.[FM_Make] = T2.[FM_Make]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[make] SELECT * FROM [temp].[make]" 

echo ==make==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[make]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Make_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"]]" 
bcp.exe [temp].[make] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Make_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Make_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[make] T1 INNER JOIN [temp].[make] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FM_Description] = T2.[FM_Description] AND T1.[FM_Make] = T2.[FM_Make]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[make] SELECT * FROM [temp].[make]" 

echo ==make==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[make]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Make_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"]]" 
bcp.exe [temp].[make] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Make_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Make_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[make] T1 INNER JOIN [temp].[make] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FM_Description] = T2.[FM_Description] AND T1.[FM_Make] = T2.[FM_Make]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[make] SELECT * FROM [temp].[make]" 

echo ==make==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[make]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Make_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"]]" 
bcp.exe [temp].[make] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Make_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Make_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[make] T1 INNER JOIN [temp].[make] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FM_Description] = T2.[FM_Description] AND T1.[FM_Make] = T2.[FM_Make]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[make] SELECT * FROM [temp].[make]" 

echo ==model==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[model]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Model_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"]]" 
bcp.exe [temp].[model] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Model_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Model_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[model] T1 INNER JOIN [temp].[model] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FMO_Make] = T2.[FMO_Make] AND T1.[FMO_ModelLine] = T2.[FMO_ModelLine]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[model] SELECT * FROM [temp].[model]" 

echo ==model==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[model]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Model_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"]]" 
bcp.exe [temp].[model] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Model_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Model_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[model] T1 INNER JOIN [temp].[model] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FMO_Make] = T2.[FMO_Make] AND T1.[FMO_ModelLine] = T2.[FMO_ModelLine]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[model] SELECT * FROM [temp].[model]" 

echo ==model==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[model]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Model_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"]]" 
bcp.exe [temp].[model] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Model_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Model_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[model] T1 INNER JOIN [temp].[model] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FMO_Make] = T2.[FMO_Make] AND T1.[FMO_ModelLine] = T2.[FMO_ModelLine]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[model] SELECT * FROM [temp].[model]" 

echo ==model==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[model]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Model_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"]]" 
bcp.exe [temp].[model] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Model_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Model_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[model] T1 INNER JOIN [temp].[model] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FMO_Make] = T2.[FMO_Make] AND T1.[FMO_ModelLine] = T2.[FMO_ModelLine]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[model] SELECT * FROM [temp].[model]" 

echo ==orderclocking==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[orderclocking]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\OrderClocking_105.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"datetime64\"], [9, \"float64\"], [10, \"float64\"], [11, \"float64\"], [12, \"float64\"], [13, \"float64\"], [14, \"float64\"], [15, \"float64\"], [16, \"float64\"], [17, \"float64\"], [18, \"float64\"], [19, \"datetime64\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"float64\"]]" 
bcp.exe [temp].[orderclocking] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\OrderClocking_105.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\OrderClocking_105.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[orderclocking] SELECT * FROM [temp].[orderclocking]" 

echo ==orderclocking==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[orderclocking]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\OrderClocking_205.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"datetime64\"], [9, \"float64\"], [10, \"float64\"], [11, \"float64\"], [12, \"float64\"], [13, \"float64\"], [14, \"float64\"], [15, \"float64\"], [16, \"float64\"], [17, \"float64\"], [18, \"float64\"], [19, \"datetime64\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"float64\"]]" 
bcp.exe [temp].[orderclocking] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\OrderClocking_205.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\OrderClocking_205.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[orderclocking] SELECT * FROM [temp].[orderclocking]" 

echo ==orderclocking==
rem Nur in Ziel:   OC_ClockingId;OC_TotalClockedTime
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[orderclocking]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\OrderClocking_305.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"datetime64\"], [9, \"float64\"], [10, \"float64\"], [11, \"float64\"], [12, \"float64\"], [13, \"float64\"], [14, \"float64\"], [15, \"float64\"], [16, \"float64\"], [17, \"float64\"], [18, \"float64\"], [19, \"datetime64\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [-1, \"object\"], [-1, \"float64\"]]" 
bcp.exe [temp].[orderclocking] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\OrderClocking_305.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\OrderClocking_305.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[orderclocking] SELECT * FROM [temp].[orderclocking]" 

echo ==orderclocking==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[orderclocking]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\OrderClocking_405.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"datetime64\"], [9, \"float64\"], [10, \"float64\"], [11, \"float64\"], [12, \"float64\"], [13, \"float64\"], [14, \"float64\"], [15, \"float64\"], [16, \"float64\"], [17, \"float64\"], [18, \"float64\"], [19, \"datetime64\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"float64\"]]" 
bcp.exe [temp].[orderclocking] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\OrderClocking_405.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\OrderClocking_405.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[orderclocking] SELECT * FROM [temp].[orderclocking]" 

echo ==organisation==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[organisation]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Organisation_105.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"]]" 
bcp.exe [temp].[organisation] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Organisation_105.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Organisation_105.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[organisation] T1 INNER JOIN [temp].[organisation] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Org_DepartmentTypeID] = T2.[Org_DepartmentTypeID] AND T1.[Org_SiteID] = T2.[Org_SiteID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[organisation] SELECT * FROM [temp].[organisation]" 

echo ==organisation==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[organisation]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Organisation_205.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"]]" 
bcp.exe [temp].[organisation] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Organisation_205.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Organisation_205.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[organisation] T1 INNER JOIN [temp].[organisation] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Org_DepartmentTypeID] = T2.[Org_DepartmentTypeID] AND T1.[Org_SiteID] = T2.[Org_SiteID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[organisation] SELECT * FROM [temp].[organisation]" 

echo ==organisation==
rem Nur in Ziel:   Org_ManagementSiteID
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[organisation]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Organisation_305.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[organisation] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Organisation_305.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Organisation_305.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[organisation] T1 INNER JOIN [temp].[organisation] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Org_DepartmentTypeID] = T2.[Org_DepartmentTypeID] AND T1.[Org_SiteID] = T2.[Org_SiteID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[organisation] SELECT * FROM [temp].[organisation]" 

echo ==organisation==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[organisation]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Organisation_405.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"]]" 
bcp.exe [temp].[organisation] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Organisation_405.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Organisation_405.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[organisation] T1 INNER JOIN [temp].[organisation] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Org_DepartmentTypeID] = T2.[Org_DepartmentTypeID] AND T1.[Org_SiteID] = T2.[Org_SiteID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[organisation] SELECT * FROM [temp].[organisation]" 

echo ==partorderheaderline==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partorderheaderline]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartOrderHeaderLine_106.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"datetime64\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"float64\"], [41, \"float64\"], [42, \"float64\"], [43, \"float64\"], [44, \"float64\"], [45, \"float64\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"], [64, \"object\"], [65, \"object\"]]" 
bcp.exe [temp].[partorderheaderline] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderHeaderLine_106.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderHeaderLine_106.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partorderheaderline] T1 INNER JOIN [temp].[partorderheaderline] T2 ON T1.[COMP] = T2.[COMP] AND T1.[PO_OrderHeader_OrderNumber] = T2.[PO_OrderHeader_OrderNumber] AND T1.[PO_OrderLine_BKOrderLineID] = T2.[PO_OrderLine_BKOrderLineID] AND T1.[PO_OrderLine_PartNumber] = T2.[PO_OrderLine_PartNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partorderheaderline] SELECT * FROM [temp].[partorderheaderline]" 

echo ==partorderheaderline==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partorderheaderline]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartOrderHeaderLine_206.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"datetime64\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"float64\"], [41, \"float64\"], [42, \"float64\"], [43, \"float64\"], [44, \"float64\"], [45, \"float64\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"], [64, \"object\"], [65, \"object\"]]" 
bcp.exe [temp].[partorderheaderline] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderHeaderLine_206.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderHeaderLine_206.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partorderheaderline] T1 INNER JOIN [temp].[partorderheaderline] T2 ON T1.[COMP] = T2.[COMP] AND T1.[PO_OrderHeader_OrderNumber] = T2.[PO_OrderHeader_OrderNumber] AND T1.[PO_OrderLine_BKOrderLineID] = T2.[PO_OrderLine_BKOrderLineID] AND T1.[PO_OrderLine_PartNumber] = T2.[PO_OrderLine_PartNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partorderheaderline] SELECT * FROM [temp].[partorderheaderline]" 

echo ==partorderheaderline==
rem Nur in Ziel:   PO_BookedInOperator;PO_CustomerContactOperator;PO_MenuGroup;PO_CreatingOperator;PO_BookedOutOperator;PO_MenuCodeNumber
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partorderheaderline]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartOrderHeaderLine_305.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"datetime64\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"float64\"], [41, \"float64\"], [42, \"float64\"], [43, \"float64\"], [44, \"float64\"], [45, \"float64\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[partorderheaderline] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderHeaderLine_305.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderHeaderLine_305.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partorderheaderline] T1 INNER JOIN [temp].[partorderheaderline] T2 ON T1.[COMP] = T2.[COMP] AND T1.[PO_OrderHeader_OrderNumber] = T2.[PO_OrderHeader_OrderNumber] AND T1.[PO_OrderLine_BKOrderLineID] = T2.[PO_OrderLine_BKOrderLineID] AND T1.[PO_OrderLine_PartNumber] = T2.[PO_OrderLine_PartNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partorderheaderline] SELECT * FROM [temp].[partorderheaderline]" 

echo ==partorderheaderline==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partorderheaderline]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartOrderHeaderLine_405.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"datetime64\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"float64\"], [41, \"float64\"], [42, \"float64\"], [43, \"float64\"], [44, \"float64\"], [45, \"float64\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"], [64, \"object\"], [65, \"object\"]]" 
bcp.exe [temp].[partorderheaderline] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderHeaderLine_405.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderHeaderLine_405.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partorderheaderline] T1 INNER JOIN [temp].[partorderheaderline] T2 ON T1.[COMP] = T2.[COMP] AND T1.[PO_OrderHeader_OrderNumber] = T2.[PO_OrderHeader_OrderNumber] AND T1.[PO_OrderLine_BKOrderLineID] = T2.[PO_OrderLine_BKOrderLineID] AND T1.[PO_OrderLine_PartNumber] = T2.[PO_OrderLine_PartNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partorderheaderline] SELECT * FROM [temp].[partorderheaderline]" 

echo ==partordertype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partordertype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartOrderType_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"]]" 
bcp.exe [temp].[partordertype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderType_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderType_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partordertype] T1 INNER JOIN [temp].[partordertype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[POT_BKPartOrderTypeID] = T2.[POT_BKPartOrderTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partordertype] SELECT * FROM [temp].[partordertype]" 

echo ==partordertype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partordertype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartOrderType_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"]]" 
bcp.exe [temp].[partordertype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderType_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderType_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partordertype] T1 INNER JOIN [temp].[partordertype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[POT_BKPartOrderTypeID] = T2.[POT_BKPartOrderTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partordertype] SELECT * FROM [temp].[partordertype]" 

echo ==partordertype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partordertype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartOrderType_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"]]" 
bcp.exe [temp].[partordertype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderType_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderType_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partordertype] T1 INNER JOIN [temp].[partordertype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[POT_BKPartOrderTypeID] = T2.[POT_BKPartOrderTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partordertype] SELECT * FROM [temp].[partordertype]" 

echo ==partordertype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partordertype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartOrderType_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"]]" 
bcp.exe [temp].[partordertype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderType_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartOrderType_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partordertype] T1 INNER JOIN [temp].[partordertype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[POT_BKPartOrderTypeID] = T2.[POT_BKPartOrderTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partordertype] SELECT * FROM [temp].[partordertype]" 

echo ==partstockdetail==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partstockdetail]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartStockDetail_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"float64\"], [7, \"float64\"], [8, \"float64\"], [9, \"float64\"], [10, \"float64\"], [11, \"object\"], [12, \"object\"], [13, \"datetime64\"], [14, \"float64\"], [15, \"object\"], [16, \"float64\"], [17, \"object\"], [18, \"object\"], [19, \"object\"]]" 
bcp.exe [temp].[partstockdetail] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartStockDetail_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartStockDetail_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partstockdetail] T1 INNER JOIN [temp].[partstockdetail] T2 ON T1.[COMP] = T2.[COMP] AND T1.[StkDetail_PartNumber] = T2.[StkDetail_PartNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partstockdetail] SELECT * FROM [temp].[partstockdetail]" 

echo ==partstockdetail==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partstockdetail]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartStockDetail_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"float64\"], [7, \"float64\"], [8, \"float64\"], [9, \"float64\"], [10, \"float64\"], [11, \"object\"], [12, \"object\"], [13, \"datetime64\"], [14, \"float64\"], [15, \"object\"], [16, \"float64\"], [17, \"object\"], [18, \"object\"], [19, \"object\"]]" 
bcp.exe [temp].[partstockdetail] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartStockDetail_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartStockDetail_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partstockdetail] T1 INNER JOIN [temp].[partstockdetail] T2 ON T1.[COMP] = T2.[COMP] AND T1.[StkDetail_PartNumber] = T2.[StkDetail_PartNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partstockdetail] SELECT * FROM [temp].[partstockdetail]" 

echo ==partstockdetail==
rem Nur in Ziel:   StkDetail_StrategicAreaID;StkDetail_DepartmentID;StkDetail_SiteID
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partstockdetail]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartStockDetail_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"float64\"], [7, \"float64\"], [8, \"float64\"], [9, \"float64\"], [10, \"float64\"], [11, \"object\"], [12, \"object\"], [13, \"datetime64\"], [14, \"float64\"], [15, \"object\"], [16, \"float64\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[partstockdetail] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartStockDetail_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartStockDetail_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partstockdetail] T1 INNER JOIN [temp].[partstockdetail] T2 ON T1.[COMP] = T2.[COMP] AND T1.[StkDetail_PartNumber] = T2.[StkDetail_PartNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partstockdetail] SELECT * FROM [temp].[partstockdetail]" 

echo ==partstockdetail==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[partstockdetail]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\PartStockDetail_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"float64\"], [7, \"float64\"], [8, \"float64\"], [9, \"float64\"], [10, \"float64\"], [11, \"object\"], [12, \"object\"], [13, \"datetime64\"], [14, \"float64\"], [15, \"object\"], [16, \"float64\"], [17, \"object\"], [18, \"object\"], [19, \"object\"]]" 
bcp.exe [temp].[partstockdetail] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartStockDetail_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\PartStockDetail_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[partstockdetail] T1 INNER JOIN [temp].[partstockdetail] T2 ON T1.[COMP] = T2.[COMP] AND T1.[StkDetail_PartNumber] = T2.[StkDetail_PartNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[partstockdetail] SELECT * FROM [temp].[partstockdetail]" 

echo ==part==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[part]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Part_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"float64\"], [28, \"float64\"], [29, \"float64\"], [30, \"float64\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"]]" 
bcp.exe [temp].[part] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Part_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Part_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[part] T1 INNER JOIN [temp].[part] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Stock_BKPartID] = T2.[Stock_BKPartID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[part] SELECT * FROM [temp].[part]" 

echo ==part==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[part]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Part_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"float64\"], [28, \"float64\"], [29, \"float64\"], [30, \"float64\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"]]" 
bcp.exe [temp].[part] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Part_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Part_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[part] T1 INNER JOIN [temp].[part] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Stock_BKPartID] = T2.[Stock_BKPartID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[part] SELECT * FROM [temp].[part]" 

echo ==part==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[part]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Part_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"float64\"], [28, \"float64\"], [29, \"float64\"], [30, \"float64\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"]]" 
bcp.exe [temp].[part] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Part_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Part_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[part] T1 INNER JOIN [temp].[part] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Stock_BKPartID] = T2.[Stock_BKPartID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[part] SELECT * FROM [temp].[part]" 

echo ==part==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[part]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Part_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"float64\"], [28, \"float64\"], [29, \"float64\"], [30, \"float64\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"]]" 
bcp.exe [temp].[part] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Part_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Part_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[part] T1 INNER JOIN [temp].[part] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Stock_BKPartID] = T2.[Stock_BKPartID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[part] SELECT * FROM [temp].[part]" 

echo ==repaircategory==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[repaircategory]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\RepairCategory_105.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[repaircategory] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairCategory_105.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairCategory_105.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[repaircategory] T1 INNER JOIN [temp].[repaircategory] T2 ON T1.[COMP] = T2.[COMP] AND T1.[RCat_BKRepairCategoryID] = T2.[RCat_BKRepairCategoryID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[repaircategory] SELECT * FROM [temp].[repaircategory]" 

echo ==repaircategory==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[repaircategory]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\RepairCategory_205.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[repaircategory] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairCategory_205.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairCategory_205.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[repaircategory] T1 INNER JOIN [temp].[repaircategory] T2 ON T1.[COMP] = T2.[COMP] AND T1.[RCat_BKRepairCategoryID] = T2.[RCat_BKRepairCategoryID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[repaircategory] SELECT * FROM [temp].[repaircategory]" 

echo ==repaircategory==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[repaircategory]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\RepairCategory_305.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[repaircategory] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairCategory_305.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairCategory_305.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[repaircategory] T1 INNER JOIN [temp].[repaircategory] T2 ON T1.[COMP] = T2.[COMP] AND T1.[RCat_BKRepairCategoryID] = T2.[RCat_BKRepairCategoryID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[repaircategory] SELECT * FROM [temp].[repaircategory]" 

echo ==repaircategory==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[repaircategory]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\RepairCategory_405.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[repaircategory] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairCategory_405.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairCategory_405.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[repaircategory] T1 INNER JOIN [temp].[repaircategory] T2 ON T1.[COMP] = T2.[COMP] AND T1.[RCat_BKRepairCategoryID] = T2.[RCat_BKRepairCategoryID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[repaircategory] SELECT * FROM [temp].[repaircategory]" 

echo ==repairgroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[repairgroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\RepairGroup_105.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[repairgroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairGroup_105.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairGroup_105.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[repairgroup] T1 INNER JOIN [temp].[repairgroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FRG_RepairGroup] = T2.[FRG_RepairGroup]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[repairgroup] SELECT * FROM [temp].[repairgroup]" 

echo ==repairgroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[repairgroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\RepairGroup_205.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[repairgroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairGroup_205.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairGroup_205.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[repairgroup] T1 INNER JOIN [temp].[repairgroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FRG_RepairGroup] = T2.[FRG_RepairGroup]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[repairgroup] SELECT * FROM [temp].[repairgroup]" 

echo ==repairgroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[repairgroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\RepairGroup_305.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[repairgroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairGroup_305.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairGroup_305.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[repairgroup] T1 INNER JOIN [temp].[repairgroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FRG_RepairGroup] = T2.[FRG_RepairGroup]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[repairgroup] SELECT * FROM [temp].[repairgroup]" 

echo ==repairgroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[repairgroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\RepairGroup_405.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"]]" 
bcp.exe [temp].[repairgroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairGroup_405.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\RepairGroup_405.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[repairgroup] T1 INNER JOIN [temp].[repairgroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FRG_RepairGroup] = T2.[FRG_RepairGroup]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[repairgroup] SELECT * FROM [temp].[repairgroup]" 

echo ==supplier==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[supplier]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Supplier_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"]]" 
bcp.exe [temp].[supplier] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Supplier_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Supplier_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[supplier] T1 INNER JOIN [temp].[supplier] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Supplier_BKSupplierID] = T2.[Supplier_BKSupplierID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[supplier] SELECT * FROM [temp].[supplier]" 

echo ==supplier==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[supplier]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Supplier_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"]]" 
bcp.exe [temp].[supplier] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Supplier_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Supplier_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[supplier] T1 INNER JOIN [temp].[supplier] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Supplier_BKSupplierID] = T2.[Supplier_BKSupplierID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[supplier] SELECT * FROM [temp].[supplier]" 

echo ==supplier==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[supplier]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Supplier_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"]]" 
bcp.exe [temp].[supplier] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Supplier_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Supplier_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[supplier] T1 INNER JOIN [temp].[supplier] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Supplier_BKSupplierID] = T2.[Supplier_BKSupplierID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[supplier] SELECT * FROM [temp].[supplier]" 

echo ==supplier==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[supplier]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Supplier_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"]]" 
bcp.exe [temp].[supplier] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Supplier_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Supplier_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[supplier] T1 INNER JOIN [temp].[supplier] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Supplier_BKSupplierID] = T2.[Supplier_BKSupplierID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[supplier] SELECT * FROM [temp].[supplier]" 

echo ==vehiclebudget==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclebudget]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleBudget_104.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"]]" 
bcp.exe [temp].[vehiclebudget] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleBudget_104.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleBudget_104.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclebudget] SELECT * FROM [temp].[vehiclebudget]" 

echo ==vehiclebudget==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclebudget]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleBudget_204.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"]]" 
bcp.exe [temp].[vehiclebudget] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleBudget_204.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleBudget_204.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclebudget] SELECT * FROM [temp].[vehiclebudget]" 

echo ==vehiclebudget==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclebudget]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleBudget_404.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"]]" 
bcp.exe [temp].[vehiclebudget] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleBudget_404.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleBudget_404.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclebudget] SELECT * FROM [temp].[vehiclebudget]" 

echo ==vehiclequotestatus==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclequotestatus]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleQuoteStatus_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclequotestatus] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteStatus_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteStatus_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclequotestatus] T1 INNER JOIN [temp].[vehiclequotestatus] T2 ON T1.[COMP] = T2.[COMP] AND T1.[QS_BKVehicleQuoteStatusID] = T2.[QS_BKVehicleQuoteStatusID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclequotestatus] SELECT * FROM [temp].[vehiclequotestatus]" 

echo ==vehiclequotestatus==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclequotestatus]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleQuoteStatus_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclequotestatus] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteStatus_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteStatus_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclequotestatus] T1 INNER JOIN [temp].[vehiclequotestatus] T2 ON T1.[COMP] = T2.[COMP] AND T1.[QS_BKVehicleQuoteStatusID] = T2.[QS_BKVehicleQuoteStatusID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclequotestatus] SELECT * FROM [temp].[vehiclequotestatus]" 

echo ==vehiclequotestatus==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclequotestatus]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleQuoteStatus_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclequotestatus] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteStatus_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteStatus_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclequotestatus] T1 INNER JOIN [temp].[vehiclequotestatus] T2 ON T1.[COMP] = T2.[COMP] AND T1.[QS_BKVehicleQuoteStatusID] = T2.[QS_BKVehicleQuoteStatusID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclequotestatus] SELECT * FROM [temp].[vehiclequotestatus]" 

echo ==vehiclequotestatus==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclequotestatus]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleQuoteStatus_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclequotestatus] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteStatus_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteStatus_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclequotestatus] T1 INNER JOIN [temp].[vehiclequotestatus] T2 ON T1.[COMP] = T2.[COMP] AND T1.[QS_BKVehicleQuoteStatusID] = T2.[QS_BKVehicleQuoteStatusID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclequotestatus] SELECT * FROM [temp].[vehiclequotestatus]" 

echo ==vehiclequotetransaction==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclequotetransaction]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleQuoteTransaction_104.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"]]" 
bcp.exe [temp].[vehiclequotetransaction] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteTransaction_104.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteTransaction_104.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclequotetransaction] T1 INNER JOIN [temp].[vehiclequotetransaction] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VQ_DepartmentTypeID] = T2.[VQ_DepartmentTypeID] AND T1.[VQ_SiteID] = T2.[VQ_SiteID] AND T1.[VQ_StrategicAreaID] = T2.[VQ_StrategicAreaID] AND T1.[VQ_VehicleQuoteID] = T2.[VQ_VehicleQuoteID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclequotetransaction] SELECT * FROM [temp].[vehiclequotetransaction]" 

echo ==vehiclequotetransaction==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclequotetransaction]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleQuoteTransaction_204.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"]]" 
bcp.exe [temp].[vehiclequotetransaction] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteTransaction_204.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteTransaction_204.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclequotetransaction] T1 INNER JOIN [temp].[vehiclequotetransaction] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VQ_DepartmentTypeID] = T2.[VQ_DepartmentTypeID] AND T1.[VQ_SiteID] = T2.[VQ_SiteID] AND T1.[VQ_StrategicAreaID] = T2.[VQ_StrategicAreaID] AND T1.[VQ_VehicleQuoteID] = T2.[VQ_VehicleQuoteID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclequotetransaction] SELECT * FROM [temp].[vehiclequotetransaction]" 

echo ==vehiclequotetransaction==
rem Nur in Ziel:   VQ_EnquiryID
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclequotetransaction]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleQuoteTransaction_304.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[vehiclequotetransaction] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteTransaction_304.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteTransaction_304.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclequotetransaction] T1 INNER JOIN [temp].[vehiclequotetransaction] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VQ_DepartmentTypeID] = T2.[VQ_DepartmentTypeID] AND T1.[VQ_SiteID] = T2.[VQ_SiteID] AND T1.[VQ_StrategicAreaID] = T2.[VQ_StrategicAreaID] AND T1.[VQ_VehicleQuoteID] = T2.[VQ_VehicleQuoteID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclequotetransaction] SELECT * FROM [temp].[vehiclequotetransaction]" 

echo ==vehiclequotetransaction==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclequotetransaction]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleQuoteTransaction_404.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"]]" 
bcp.exe [temp].[vehiclequotetransaction] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteTransaction_404.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleQuoteTransaction_404.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclequotetransaction] T1 INNER JOIN [temp].[vehiclequotetransaction] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VQ_DepartmentTypeID] = T2.[VQ_DepartmentTypeID] AND T1.[VQ_SiteID] = T2.[VQ_SiteID] AND T1.[VQ_StrategicAreaID] = T2.[VQ_StrategicAreaID] AND T1.[VQ_VehicleQuoteID] = T2.[VQ_VehicleQuoteID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclequotetransaction] SELECT * FROM [temp].[vehiclequotetransaction]" 

echo ==vehiclesalestype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclesalestype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleSalesType_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclesalestype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleSalesType_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleSalesType_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclesalestype] T1 INNER JOIN [temp].[vehiclesalestype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VSType_BKVehicleSalesTypeID] = T2.[VSType_BKVehicleSalesTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclesalestype] SELECT * FROM [temp].[vehiclesalestype]" 

echo ==vehiclesalestype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclesalestype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleSalesType_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclesalestype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleSalesType_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleSalesType_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclesalestype] T1 INNER JOIN [temp].[vehiclesalestype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VSType_BKVehicleSalesTypeID] = T2.[VSType_BKVehicleSalesTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclesalestype] SELECT * FROM [temp].[vehiclesalestype]" 

echo ==vehiclesalestype==
rem Nur in Quelle: VStatus_DMSDescription;VStatus_DMSSalesType;VStatus_BKVehicleSalesTypeID
rem Nur in Ziel:   VSType_DMSDescription;VSType_BKVehicleSalesTypeID;VSType_DMSSalesType
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclesalestype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleSalesType_307.csv" -t "[[0, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[vehiclesalestype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleSalesType_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleSalesType_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclesalestype] T1 INNER JOIN [temp].[vehiclesalestype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VSType_BKVehicleSalesTypeID] = T2.[VSType_BKVehicleSalesTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclesalestype] SELECT * FROM [temp].[vehiclesalestype]" 

echo ==vehiclesalestype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclesalestype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleSalesType_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclesalestype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleSalesType_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleSalesType_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclesalestype] T1 INNER JOIN [temp].[vehiclesalestype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VSType_BKVehicleSalesTypeID] = T2.[VSType_BKVehicleSalesTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclesalestype] SELECT * FROM [temp].[vehiclesalestype]" 

echo ==vehiclestatus==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclestatus]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleStatus_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclestatus] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleStatus_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleStatus_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclestatus] T1 INNER JOIN [temp].[vehiclestatus] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VStatus_BKVehicleStatusID] = T2.[VStatus_BKVehicleStatusID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclestatus] SELECT * FROM [temp].[vehiclestatus]" 

echo ==vehiclestatus==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclestatus]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleStatus_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclestatus] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleStatus_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleStatus_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclestatus] T1 INNER JOIN [temp].[vehiclestatus] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VStatus_BKVehicleStatusID] = T2.[VStatus_BKVehicleStatusID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclestatus] SELECT * FROM [temp].[vehiclestatus]" 

echo ==vehiclestatus==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclestatus]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleStatus_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclestatus] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleStatus_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleStatus_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclestatus] T1 INNER JOIN [temp].[vehiclestatus] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VStatus_BKVehicleStatusID] = T2.[VStatus_BKVehicleStatusID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclestatus] SELECT * FROM [temp].[vehiclestatus]" 

echo ==vehiclestatus==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehiclestatus]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleStatus_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehiclestatus] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleStatus_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleStatus_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehiclestatus] T1 INNER JOIN [temp].[vehiclestatus] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VStatus_BKVehicleStatusID] = T2.[VStatus_BKVehicleStatusID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehiclestatus] SELECT * FROM [temp].[vehiclestatus]" 

echo ==vehicletransactiontype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicletransactiontype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleTransactionType_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehicletransactiontype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransactionType_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransactionType_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicletransactiontype] T1 INNER JOIN [temp].[vehicletransactiontype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VTT_BKVehicleTransactionTypeID] = T2.[VTT_BKVehicleTransactionTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicletransactiontype] SELECT * FROM [temp].[vehicletransactiontype]" 

echo ==vehicletransactiontype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicletransactiontype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleTransactionType_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehicletransactiontype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransactionType_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransactionType_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicletransactiontype] T1 INNER JOIN [temp].[vehicletransactiontype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VTT_BKVehicleTransactionTypeID] = T2.[VTT_BKVehicleTransactionTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicletransactiontype] SELECT * FROM [temp].[vehicletransactiontype]" 

echo ==vehicletransactiontype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicletransactiontype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleTransactionType_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehicletransactiontype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransactionType_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransactionType_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicletransactiontype] T1 INNER JOIN [temp].[vehicletransactiontype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VTT_BKVehicleTransactionTypeID] = T2.[VTT_BKVehicleTransactionTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicletransactiontype] SELECT * FROM [temp].[vehicletransactiontype]" 

echo ==vehicletransactiontype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicletransactiontype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleTransactionType_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[vehicletransactiontype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransactionType_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransactionType_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicletransactiontype] T1 INNER JOIN [temp].[vehicletransactiontype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VTT_BKVehicleTransactionTypeID] = T2.[VTT_BKVehicleTransactionTypeID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicletransactiontype] SELECT * FROM [temp].[vehicletransactiontype]" 

echo ==vehicletransaction==
rem C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleTransaction_104.csv fehlerhaft!
echo ==vehicletransaction==
rem C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleTransaction_204.csv fehlerhaft!
echo ==vehicletransaction==
rem Nur in Quelle: VT_InvoiceCustomer
rem Nur in Ziel:   VT_InvoiceCustomerNumber;VT_TrueCost;VT_InvType;VT_RTranDat
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicletransaction]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleTransaction_304.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"float64\"], [15, \"object\"], [16, \"datetime64\"], [17, \"object\"], [18, \"object\"], [19, \"datetime64\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [-1, \"object\"], [-1, \"float64\"], [-1, \"datetime64\"], [-1, \"object\"]]" 
bcp.exe [temp].[vehicletransaction] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransaction_304.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransaction_304.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicletransaction] T1 INNER JOIN [temp].[vehicletransaction] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VT_BKVehicleID] = T2.[VT_BKVehicleID] AND T1.[VT_InvoiceNumber] = T2.[VT_InvoiceNumber] AND T1.[VT_OptionSequence] = T2.[VT_OptionSequence] AND T1.[VT_TransactionType] = T2.[VT_TransactionType]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicletransaction] SELECT * FROM [temp].[vehicletransaction]" 

echo ==vehicletransaction==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicletransaction]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleTransaction_404.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"float64\"], [15, \"object\"], [16, \"datetime64\"], [17, \"object\"], [18, \"object\"], [19, \"datetime64\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"float64\"], [29, \"datetime64\"], [30, \"object\"]]" 
bcp.exe [temp].[vehicletransaction] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransaction_404.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransaction_404.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicletransaction] T1 INNER JOIN [temp].[vehicletransaction] T2 ON T1.[COMP] = T2.[COMP] AND T1.[VT_BKVehicleID] = T2.[VT_BKVehicleID] AND T1.[VT_InvoiceNumber] = T2.[VT_InvoiceNumber] AND T1.[VT_OptionSequence] = T2.[VT_OptionSequence] AND T1.[VT_TransactionType] = T2.[VT_TransactionType]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicletransaction] SELECT * FROM [temp].[vehicletransaction]" 

echo ==vehicletype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicletype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleType_107.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"]]" 
bcp.exe [temp].[vehicletype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleType_107.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleType_107.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicletype] T1 INNER JOIN [temp].[vehicletype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FVT_VehicleType] = T2.[FVT_VehicleType]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicletype] SELECT * FROM [temp].[vehicletype]" 

echo ==vehicletype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicletype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleType_207.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"]]" 
bcp.exe [temp].[vehicletype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleType_207.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleType_207.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicletype] T1 INNER JOIN [temp].[vehicletype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FVT_VehicleType] = T2.[FVT_VehicleType]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicletype] SELECT * FROM [temp].[vehicletype]" 

echo ==vehicletype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicletype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleType_307.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"]]" 
bcp.exe [temp].[vehicletype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleType_307.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleType_307.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicletype] T1 INNER JOIN [temp].[vehicletype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FVT_VehicleType] = T2.[FVT_VehicleType]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicletype] SELECT * FROM [temp].[vehicletype]" 

echo ==vehicletype==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicletype]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\VehicleType_407.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"]]" 
bcp.exe [temp].[vehicletype] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleType_407.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleType_407.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicletype] T1 INNER JOIN [temp].[vehicletype] T2 ON T1.[COMP] = T2.[COMP] AND T1.[FVT_VehicleType] = T2.[FVT_VehicleType]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicletype] SELECT * FROM [temp].[vehicletype]" 

echo ==vehicle==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicle]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Vehicle_104.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"object\"], [41, \"object\"], [42, \"object\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"], [64, \"object\"], [65, \"object\"], [66, \"object\"], [67, \"object\"], [68, \"object\"], [69, \"object\"]]" 
bcp.exe [temp].[vehicle] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Vehicle_104.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Vehicle_104.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicle] T1 INNER JOIN [temp].[vehicle] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Vehicle_BKVehicleID] = T2.[Vehicle_BKVehicleID] AND T1.[Vehicle_CRMVehicleNumber] = T2.[Vehicle_CRMVehicleNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicle] SELECT * FROM [temp].[vehicle]" 

echo ==vehicle==
rem Nur in Quelle: Vehicle_MS_BIcom_Vehicle_VehicleWarrantyExpiryDate;Vehicle_MS_BIcom_Vehicle_EconomicStockDate;Vehicle_MS_BIcom_Vehicle_PreviousUsage;Vehicle_MS_BIcom_Vehicle_WorkshopModelID;Vehicle_MS_BIcom_Vehicle_MakeID;Vehicle_MS_BIcom_Vehicle_ModelID;Vehicle_MS_BIcom_Vehicle_ArrivalDate;Vehicle_MS_BIcom_Vehicle_VehicleModelDescription;Vehicle_MS_BIcom_Vehicle_BodyStyleCode;Vehicle_MS_BIcom_Vehicle_CreatingSiteID;Vehicle_MS_BIcom_Vehicle_BuildDate;Vehicle_MS_BIcom_Vehicle_PaymentDate;Vehicle_MS_BIcom_Vehicle_VehicleGroup;Vehicle_MS_BIcom_Vehicle_ChassisNumber;Vehicle_MS_BIcom_Vehicle_Mileage;Vehicle_MS_BIcom_Vehicle_ModelLine;Vehicle_MS_BIcom_Vehicle_ModelYear;Vehicle_MS_BIcom_Vehicle_PhysicalLocation;Vehicle_MS_BIcom_Vehicle_Veh_FinanceAgreementNumbe;Vehicle_MS_BIcom_Vehicle_CreatingStrategicAreaID;Vehicle_MS_BIcom_Vehicle_EngineSize;Vehicle_MS_BIcom_Vehicle_LiveStatus;Vehicle_MS_BIcom_Vehicle_RegisterNumber;Vehicle_MS_BIcom_Vehicle_CRMVehicleNumber;Vehicle_MS_BIcom_Vehicle_Veh_ExtendedWarrantyRefer;Vehicle_MS_BIcom_Vehicle_Veh_PreviousRegistrationP;Vehicle_MS_BIcom_Vehicle_VatTreatment;Vehicle_MS_BIcom_Vehicle_BookkeepingCode;Vehicle_MS_BIcom_Vehicle_BuyingLocation;Vehicle_MS_BIcom_Vehicle_PhysicalStockDate;Vehicle_MS_BIcom_Vehicle_PurchOrderNumber;Vehicle_MS_BIcom_Vehicle_DMSFuelTypeCode;Vehicle_MS_BIcom_Vehicle_FirstRegistrationDate;Vehicle_MS_BIcom_Vehicle_DMSTrimCode;Vehicle_MS_BIcom_Vehicle_BodyStyleDescription;Vehicle_MS_BIcom_Vehicle_DeliveryDate;Vehicle_MS_BIcom_Vehicle_AirConditioning;Vehicle_MS_BIcom_Vehicle_Commision;Vehicle_MS_BIcom_Vehicle_FactoryDeliveryDate;Vehicle_MS_BIcom_Vehicle_DMSColorCode;Vehicle_MS_BIcom_Vehicle_Active;Vehicle_MS_BIcom_Vehicle_InterestFreeExpiryDate;Vehicle_MS_BIcom_Vehicle_BKVehicleID;Vehicle_MS_BIcom_Vehicle_ConsignmentDate;Vehicle_MS_BIcom_Vehicle_GoodsReceiptNumber;Vehicle_MS_BIcom_Vehicle_CompanyVehicle;Vehicle_MS_BIcom_Vehicle_FirstInternalInvoiceDate;Vehicle_MS_BIcom_Vehicle_PurchOrderType;Vehicle_MS_BIcom_Vehicle_Make;Vehicle_MS_BIcom_Vehicle_VehicleType;Vehicle_MS_BIcom_Vehicle_AutomaticGear;Vehicle_MS_BIcom_Vehicle_GovermentNumber;Vehicle_MS_BIcom_Vehicle_PurchaseOrderdate;Vehicle_MS_BIcom_Vehicle_VehicleModelGroupCode;Vehicle_MS_BIcom_Vehicle_ModelLineID;Vehicle_MS_BIcom_Vehicle_AlloyWheels;Vehicle_MS_BIcom_Vehicle_Model;Vehicle_MS_BIcom_Vehicle_DMSVehicleNumber;Vehicle_MS_BIcom_Vehicle_VehicleStatus;Vehicle_MS_BIcom_Vehicle_ReservationSalesman;Vehicle_MS_BIcom_Vehicle_VehicleCreationDate;Vehicle_MS_BIcom_Vehicle_WorkshopModel;Vehicle_MS_BIcom_Vehicle_SalesDate;Vehicle_MS_BIcom_Vehicle_ReservationDate;Vehicle_MS_BIcom_Vehicle_Veh_EngineNumber;Vehicle_MS_BIcom_Vehicle_Demo;Vehicle_MS_BIcom_Vehicle_SalesOrderDate;Vehicle_MS_BIcom_Vehicle_CreatingDepartmentID;Vehicle_MS_BIcom_Vehicle_PreviousLastName
rem Nur in Ziel:   Vehicle_VehicleGroup;Vehicle_BookkeepingCode;Vehicle_Veh_ExtendedWarrantyReferenceCode;Vehicle_Veh_FinanceAgreementNumber;Vehicle_BuildDate;Vehicle_ReservationDate;Vehicle_AutomaticGear;Vehicle_AirConditioning;Vehicle_PurchOrderType;Vehicle_ReservationSalesman;Vehicle_AlloyWheels;Vehicle_VehicleModelDescription;Vehicle_RegisterNumber;Vehicle_Commision;Vehicle_FactoryDeliveryDate;Vehicle_MakeID;Vehicle_InterestFreeExpiryDate;Vehicle_EngineSize;Vehicle_DMSFuelTypeCode;Vehicle_ConsignmentDate;Vehicle_WorkshopModelID;Vehicle_DMSColorCode;Vehicle_SalesDate;Vehicle_Veh_PreviousRegistrationPlace;Vehicle_CreatingSiteID;Vehicle_VatTreatment;Vehicle_GovermentNumber;Vehicle_BKVehicleID;Vehicle_DMSVehicleNumber;Vehicle_EconomicStockDate;Vehicle_CRMVehicleNumber;Vehicle_VehicleStatus;Vehicle_BodyStyleCode;Vehicle_PurchaseOrderdate;Vehicle_FirstRegistrationDate;Vehicle_PurchOrderNumber;Vehicle_LiveStatus;Vehicle_VehicleWarrantyExpiryDate;Vehicle_PreviousUsage;Vehicle_VehicleModelGroupCode;Vehicle_PaymentDate;Vehicle_ArrivalDate;Vehicle_GoodsReceiptNumber;Vehicle_FirstInternalInvoiceDate;Vehicle_BodyStyleDescription;Vehicle_ChassisNumber;Vehicle_ModelYear;Vehicle_CreatingDepartmentID;Vehicle_VehicleType;Vehicle_ModelLine;Vehicle_Active;Vehicle_PreviousLastName;Vehicle_DeliveryDate;Vehicle_CreatingStrategicAreaID;Vehicle_ModelLineID;Vehicle_Model;Vehicle_CompanyVehicle;Vehicle_Veh_EngineNumber;Vehicle_ModelID;Vehicle_DMSTrimCode;Vehicle_Mileage;Vehicle_SalesOrderDate;Vehicle_BuyingLocation;Vehicle_PhysicalStockDate;Vehicle_PhysicalLocation;Vehicle_Demo;Vehicle_VehicleCreationDate;Vehicle_Make;Vehicle_WorkshopModel
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicle]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Vehicle_204.csv" -t "[[0, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[vehicle] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Vehicle_204.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Vehicle_204.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicle] T1 INNER JOIN [temp].[vehicle] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Vehicle_BKVehicleID] = T2.[Vehicle_BKVehicleID] AND T1.[Vehicle_CRMVehicleNumber] = T2.[Vehicle_CRMVehicleNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicle] SELECT * FROM [temp].[vehicle]" 

echo ==vehicle==
rem Nur in Ziel:   Vehicle_LiveStatus;Vehicle_EngineSize;Vehicle_VehicleWarrantyExpiryDate;Vehicle_VehicleModelGroupCode;Vehicle_CompanyVehicle;Vehicle_GovermentNumber;Vehicle_BuyingLocation;Vehicle_VehicleModelDescription
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicle]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Vehicle_304.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"object\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"object\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"object\"], [35, \"object\"], [36, \"object\"], [37, \"object\"], [38, \"object\"], [39, \"object\"], [40, \"object\"], [41, \"object\"], [42, \"object\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[vehicle] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Vehicle_304.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Vehicle_304.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicle] T1 INNER JOIN [temp].[vehicle] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Vehicle_BKVehicleID] = T2.[Vehicle_BKVehicleID] AND T1.[Vehicle_CRMVehicleNumber] = T2.[Vehicle_CRMVehicleNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicle] SELECT * FROM [temp].[vehicle]" 

echo ==vehicle==
rem Nur in Quelle: Vehicle_MS_BIcom_Vehicle_VehicleWarrantyExpiryDate;Vehicle_MS_BIcom_Vehicle_EconomicStockDate;Vehicle_MS_BIcom_Vehicle_PreviousUsage;Vehicle_MS_BIcom_Vehicle_WorkshopModelID;Vehicle_MS_BIcom_Vehicle_MakeID;Vehicle_MS_BIcom_Vehicle_ModelID;Vehicle_MS_BIcom_Vehicle_ArrivalDate;Vehicle_MS_BIcom_Vehicle_VehicleModelDescription;Vehicle_MS_BIcom_Vehicle_BodyStyleCode;Vehicle_MS_BIcom_Vehicle_CreatingSiteID;Vehicle_MS_BIcom_Vehicle_BuildDate;Vehicle_MS_BIcom_Vehicle_PaymentDate;Vehicle_MS_BIcom_Vehicle_VehicleGroup;Vehicle_MS_BIcom_Vehicle_ChassisNumber;Vehicle_MS_BIcom_Vehicle_Mileage;Vehicle_MS_BIcom_Vehicle_ModelLine;Vehicle_MS_BIcom_Vehicle_ModelYear;Vehicle_MS_BIcom_Vehicle_PhysicalLocation;Vehicle_MS_BIcom_Vehicle_Veh_FinanceAgreementNumbe;Vehicle_MS_BIcom_Vehicle_CreatingStrategicAreaID;Vehicle_MS_BIcom_Vehicle_EngineSize;Vehicle_MS_BIcom_Vehicle_LiveStatus;Vehicle_MS_BIcom_Vehicle_RegisterNumber;Vehicle_MS_BIcom_Vehicle_CRMVehicleNumber;Vehicle_MS_BIcom_Vehicle_Veh_ExtendedWarrantyRefer;Vehicle_MS_BIcom_Vehicle_Veh_PreviousRegistrationP;Vehicle_MS_BIcom_Vehicle_VatTreatment;Vehicle_MS_BIcom_Vehicle_BookkeepingCode;Vehicle_MS_BIcom_Vehicle_BuyingLocation;Vehicle_MS_BIcom_Vehicle_PhysicalStockDate;Vehicle_MS_BIcom_Vehicle_PurchOrderNumber;Vehicle_MS_BIcom_Vehicle_DMSFuelTypeCode;Vehicle_MS_BIcom_Vehicle_FirstRegistrationDate;Vehicle_MS_BIcom_Vehicle_DMSTrimCode;Vehicle_MS_BIcom_Vehicle_BodyStyleDescription;Vehicle_MS_BIcom_Vehicle_DeliveryDate;Vehicle_MS_BIcom_Vehicle_AirConditioning;Vehicle_MS_BIcom_Vehicle_Commision;Vehicle_MS_BIcom_Vehicle_FactoryDeliveryDate;Vehicle_MS_BIcom_Vehicle_DMSColorCode;Vehicle_MS_BIcom_Vehicle_Active;Vehicle_MS_BIcom_Vehicle_InterestFreeExpiryDate;Vehicle_MS_BIcom_Vehicle_BKVehicleID;Vehicle_MS_BIcom_Vehicle_ConsignmentDate;Vehicle_MS_BIcom_Vehicle_GoodsReceiptNumber;Vehicle_MS_BIcom_Vehicle_CompanyVehicle;Vehicle_MS_BIcom_Vehicle_FirstInternalInvoiceDate;Vehicle_MS_BIcom_Vehicle_PurchOrderType;Vehicle_MS_BIcom_Vehicle_Make;Vehicle_MS_BIcom_Vehicle_VehicleType;Vehicle_MS_BIcom_Vehicle_AutomaticGear;Vehicle_MS_BIcom_Vehicle_GovermentNumber;Vehicle_MS_BIcom_Vehicle_PurchaseOrderdate;Vehicle_MS_BIcom_Vehicle_VehicleModelGroupCode;Vehicle_MS_BIcom_Vehicle_ModelLineID;Vehicle_MS_BIcom_Vehicle_AlloyWheels;Vehicle_MS_BIcom_Vehicle_Model;Vehicle_MS_BIcom_Vehicle_DMSVehicleNumber;Vehicle_MS_BIcom_Vehicle_VehicleStatus;Vehicle_MS_BIcom_Vehicle_ReservationSalesman;Vehicle_MS_BIcom_Vehicle_VehicleCreationDate;Vehicle_MS_BIcom_Vehicle_WorkshopModel;Vehicle_MS_BIcom_Vehicle_SalesDate;Vehicle_MS_BIcom_Vehicle_ReservationDate;Vehicle_MS_BIcom_Vehicle_Veh_EngineNumber;Vehicle_MS_BIcom_Vehicle_Demo;Vehicle_MS_BIcom_Vehicle_SalesOrderDate;Vehicle_MS_BIcom_Vehicle_CreatingDepartmentID;Vehicle_MS_BIcom_Vehicle_PreviousLastName
rem Nur in Ziel:   Vehicle_VehicleGroup;Vehicle_BookkeepingCode;Vehicle_Veh_ExtendedWarrantyReferenceCode;Vehicle_Veh_FinanceAgreementNumber;Vehicle_BuildDate;Vehicle_ReservationDate;Vehicle_AutomaticGear;Vehicle_AirConditioning;Vehicle_PurchOrderType;Vehicle_ReservationSalesman;Vehicle_AlloyWheels;Vehicle_VehicleModelDescription;Vehicle_RegisterNumber;Vehicle_Commision;Vehicle_FactoryDeliveryDate;Vehicle_MakeID;Vehicle_InterestFreeExpiryDate;Vehicle_EngineSize;Vehicle_DMSFuelTypeCode;Vehicle_ConsignmentDate;Vehicle_WorkshopModelID;Vehicle_DMSColorCode;Vehicle_SalesDate;Vehicle_Veh_PreviousRegistrationPlace;Vehicle_CreatingSiteID;Vehicle_VatTreatment;Vehicle_GovermentNumber;Vehicle_BKVehicleID;Vehicle_DMSVehicleNumber;Vehicle_EconomicStockDate;Vehicle_CRMVehicleNumber;Vehicle_VehicleStatus;Vehicle_BodyStyleCode;Vehicle_PurchaseOrderdate;Vehicle_FirstRegistrationDate;Vehicle_PurchOrderNumber;Vehicle_LiveStatus;Vehicle_VehicleWarrantyExpiryDate;Vehicle_PreviousUsage;Vehicle_VehicleModelGroupCode;Vehicle_PaymentDate;Vehicle_ArrivalDate;Vehicle_GoodsReceiptNumber;Vehicle_FirstInternalInvoiceDate;Vehicle_BodyStyleDescription;Vehicle_ChassisNumber;Vehicle_ModelYear;Vehicle_CreatingDepartmentID;Vehicle_VehicleType;Vehicle_ModelLine;Vehicle_Active;Vehicle_PreviousLastName;Vehicle_DeliveryDate;Vehicle_CreatingStrategicAreaID;Vehicle_ModelLineID;Vehicle_Model;Vehicle_CompanyVehicle;Vehicle_Veh_EngineNumber;Vehicle_ModelID;Vehicle_DMSTrimCode;Vehicle_Mileage;Vehicle_SalesOrderDate;Vehicle_BuyingLocation;Vehicle_PhysicalStockDate;Vehicle_PhysicalLocation;Vehicle_Demo;Vehicle_VehicleCreationDate;Vehicle_Make;Vehicle_WorkshopModel
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[vehicle]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Vehicle_404.csv" -t "[[0, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[vehicle] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Vehicle_404.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Vehicle_404.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[vehicle] T1 INNER JOIN [temp].[vehicle] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Vehicle_BKVehicleID] = T2.[Vehicle_BKVehicleID] AND T1.[Vehicle_CRMVehicleNumber] = T2.[Vehicle_CRMVehicleNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[vehicle] SELECT * FROM [temp].[vehicle]" 

echo ==workgroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[workgroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Workgroup_105.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[workgroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Workgroup_105.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Workgroup_105.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[workgroup] T1 INNER JOIN [temp].[workgroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Workgroup_BKWorkgroupID] = T2.[Workgroup_BKWorkgroupID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[workgroup] SELECT * FROM [temp].[workgroup]" 

echo ==workgroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[workgroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Workgroup_205.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[workgroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Workgroup_205.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Workgroup_205.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[workgroup] T1 INNER JOIN [temp].[workgroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Workgroup_BKWorkgroupID] = T2.[Workgroup_BKWorkgroupID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[workgroup] SELECT * FROM [temp].[workgroup]" 

echo ==workgroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[workgroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Workgroup_305.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[workgroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Workgroup_305.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Workgroup_305.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[workgroup] T1 INNER JOIN [temp].[workgroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Workgroup_BKWorkgroupID] = T2.[Workgroup_BKWorkgroupID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[workgroup] SELECT * FROM [temp].[workgroup]" 

echo ==workgroup==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[workgroup]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\Workgroup_405.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"]]" 
bcp.exe [temp].[workgroup] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Workgroup_405.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\Workgroup_405.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[workgroup] T1 INNER JOIN [temp].[workgroup] T2 ON T1.[COMP] = T2.[COMP] AND T1.[Workgroup_BKWorkgroupID] = T2.[Workgroup_BKWorkgroupID]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[workgroup] SELECT * FROM [temp].[workgroup]" 

echo ==workshoporderheaderline==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[workshoporderheaderline]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\WorkshopOrderHeaderLine_105.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"float64\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"float64\"], [35, \"float64\"], [36, \"float64\"], [37, \"float64\"], [38, \"float64\"], [39, \"float64\"], [40, \"float64\"], [41, \"float64\"], [42, \"float64\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"]]" 
bcp.exe [temp].[workshoporderheaderline] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\WorkshopOrderHeaderLine_105.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\WorkshopOrderHeaderLine_105.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[workshoporderheaderline] T1 INNER JOIN [temp].[workshoporderheaderline] T2 ON T1.[COMP] = T2.[COMP] AND T1.[SO headr_OrderHeader_OrderNumber] = T2.[SO headr_OrderHeader_OrderNumber] AND T1.[SO headr_OrderLine_BKOrderLineID] = T2.[SO headr_OrderLine_BKOrderLineID] AND T1.[SO headr_OrderLine_LineNumber] = T2.[SO headr_OrderLine_LineNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[workshoporderheaderline] SELECT * FROM [temp].[workshoporderheaderline]" 

echo ==workshoporderheaderline==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[workshoporderheaderline]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\WorkshopOrderHeaderLine_205.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"float64\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"float64\"], [35, \"float64\"], [36, \"float64\"], [37, \"float64\"], [38, \"float64\"], [39, \"float64\"], [40, \"float64\"], [41, \"float64\"], [42, \"float64\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"]]" 
bcp.exe [temp].[workshoporderheaderline] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\WorkshopOrderHeaderLine_205.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\WorkshopOrderHeaderLine_205.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[workshoporderheaderline] T1 INNER JOIN [temp].[workshoporderheaderline] T2 ON T1.[COMP] = T2.[COMP] AND T1.[SO headr_OrderHeader_OrderNumber] = T2.[SO headr_OrderHeader_OrderNumber] AND T1.[SO headr_OrderLine_BKOrderLineID] = T2.[SO headr_OrderLine_BKOrderLineID] AND T1.[SO headr_OrderLine_LineNumber] = T2.[SO headr_OrderLine_LineNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[workshoporderheaderline] SELECT * FROM [temp].[workshoporderheaderline]" 

echo ==workshoporderheaderline==
rem Nur in Ziel:   SO headr_OHL_PlannedCheckOutDate;SO headr_OHL_PlannedCheckInDate;SO headr_OHL_MenuCodeNumber;SO headr_OHL_CreatingOperator;SO headr_OHL_BookedOutOperator;SO headr_OHL_CustomerContactOperator;SO headr_OHL_MenuGroup;SO headr_OHL_BookedInOperator
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[workshoporderheaderline]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\WorkshopOrderHeaderLine_305.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"float64\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"float64\"], [35, \"float64\"], [36, \"float64\"], [37, \"float64\"], [38, \"float64\"], [39, \"float64\"], [40, \"float64\"], [41, \"float64\"], [42, \"float64\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"], [-1, \"object\"]]" 
bcp.exe [temp].[workshoporderheaderline] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\WorkshopOrderHeaderLine_305.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\WorkshopOrderHeaderLine_305.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[workshoporderheaderline] T1 INNER JOIN [temp].[workshoporderheaderline] T2 ON T1.[COMP] = T2.[COMP] AND T1.[SO headr_OrderHeader_OrderNumber] = T2.[SO headr_OrderHeader_OrderNumber] AND T1.[SO headr_OrderLine_BKOrderLineID] = T2.[SO headr_OrderLine_BKOrderLineID] AND T1.[SO headr_OrderLine_LineNumber] = T2.[SO headr_OrderLine_LineNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[workshoporderheaderline] SELECT * FROM [temp].[workshoporderheaderline]" 

echo ==workshoporderheaderline==
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [temp].[workshoporderheaderline]" 
%PYTHON%\python.exe csv_import.py transform "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\WorkshopOrderHeaderLine_405.csv" -t "[[0, \"object\"], [1, \"object\"], [2, \"object\"], [3, \"object\"], [4, \"object\"], [5, \"datetime64\"], [6, \"object\"], [7, \"object\"], [8, \"object\"], [9, \"object\"], [10, \"object\"], [11, \"object\"], [12, \"object\"], [13, \"object\"], [14, \"object\"], [15, \"object\"], [16, \"object\"], [17, \"object\"], [18, \"object\"], [19, \"object\"], [20, \"object\"], [21, \"object\"], [22, \"object\"], [23, \"object\"], [24, \"object\"], [25, \"float64\"], [26, \"object\"], [27, \"object\"], [28, \"object\"], [29, \"object\"], [30, \"object\"], [31, \"object\"], [32, \"object\"], [33, \"object\"], [34, \"float64\"], [35, \"float64\"], [36, \"float64\"], [37, \"float64\"], [38, \"float64\"], [39, \"float64\"], [40, \"float64\"], [41, \"float64\"], [42, \"float64\"], [43, \"object\"], [44, \"object\"], [45, \"object\"], [46, \"object\"], [47, \"object\"], [48, \"object\"], [49, \"object\"], [50, \"object\"], [51, \"object\"], [52, \"object\"], [53, \"object\"], [54, \"object\"], [55, \"object\"], [56, \"object\"], [57, \"object\"], [58, \"object\"], [59, \"object\"], [60, \"object\"], [61, \"object\"], [62, \"object\"], [63, \"object\"]]" 
bcp.exe [temp].[workshoporderheaderline] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\WorkshopOrderHeaderLine_405.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\WorkshopOrderHeaderLine_405.csv.log" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "DELETE T1 FROM [import].[workshoporderheaderline] T1 INNER JOIN [temp].[workshoporderheaderline] T2 ON T1.[COMP] = T2.[COMP] AND T1.[SO headr_OrderHeader_OrderNumber] = T2.[SO headr_OrderHeader_OrderNumber] AND T1.[SO headr_OrderLine_BKOrderLineID] = T2.[SO headr_OrderLine_BKOrderLineID] AND T1.[SO headr_OrderLine_LineNumber] = T2.[SO headr_OrderLine_LineNumber]" 
sqlcmd.exe -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -p -Q "INSERT INTO [import].[workshoporderheaderline] SELECT * FROM [temp].[workshoporderheaderline]"