@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== 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_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\"], [66, \"object\"], [67, \"object\"], [68, \"object\"], [69, \"object\"]]" bcp.exe [temp].[crmvehicle] in "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMVehicle_106.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\CRMVehicle_106.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_VehicleWarrantyExpiryDate;Vehicle_VehicleModelGroupCode;Vehicle_CompanyVehicle;Vehicle_LiveStatus;Vehicle_EngineSize 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_VehicleWarrantyExpiryDate;Vehicle_VehicleModelGroupCode;Vehicle_CompanyVehicle;Vehicle_BuyingLocation;Vehicle_LiveStatus;Vehicle_EngineSize;Vehicle_VehicleModelDescription;Vehicle_GovermentNumber 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_TPSONEmail;Cust_LastName;Cust_DoNotContact;Cust_FirstName;Cust_CustomerStatus;Cust_Title;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_TotalClockedTime;OC_ClockingId 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_CustomerContactOperator;PO_BookedInOperator;PO_MenuCodeNumber;PO_CreatingOperator;PO_BookedOutOperator;PO_MenuGroup 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_BKVehicleSalesTypeID;VStatus_DMSSalesType rem Nur in Ziel: VSType_DMSSalesType;VSType_DMSDescription;VSType_BKVehicleSalesTypeID 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== 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_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, \"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_104.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransaction_104.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_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, \"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_204.csv" -S GC-SERVER1\GLOBALCUBE -d AUTOLINE -U sa -P Mffu3011# -c -C 65001 -e "C:\GlobalCube\System\AUTOLINE\Datenbank\Full_zusammengesetllt\stage\VehicleTransaction_204.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== rem Nur in Quelle: VT_InvoiceCustomer rem Nur in Ziel: VT_RTranDat;VT_InvType;VT_InvoiceCustomerNumber;VT_TrueCost 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_Veh_ExtendedWarrantyRefer;Vehicle_MS_BIcom_Vehicle_AlloyWheels;Vehicle_MS_BIcom_Vehicle_FactoryDeliveryDate;Vehicle_MS_BIcom_Vehicle_ChassisNumber;Vehicle_MS_BIcom_Vehicle_PaymentDate;Vehicle_MS_BIcom_Vehicle_CreatingDepartmentID;Vehicle_MS_BIcom_Vehicle_FirstRegistrationDate;Vehicle_MS_BIcom_Vehicle_Make;Vehicle_MS_BIcom_Vehicle_CreatingStrategicAreaID;Vehicle_MS_BIcom_Vehicle_VatTreatment;Vehicle_MS_BIcom_Vehicle_PreviousUsage;Vehicle_MS_BIcom_Vehicle_DeliveryDate;Vehicle_MS_BIcom_Vehicle_Model;Vehicle_MS_BIcom_Vehicle_PurchOrderNumber;Vehicle_MS_BIcom_Vehicle_DMSColorCode;Vehicle_MS_BIcom_Vehicle_PurchaseOrderdate;Vehicle_MS_BIcom_Vehicle_GoodsReceiptNumber;Vehicle_MS_BIcom_Vehicle_GovermentNumber;Vehicle_MS_BIcom_Vehicle_WorkshopModelID;Vehicle_MS_BIcom_Vehicle_BodyStyleDescription;Vehicle_MS_BIcom_Vehicle_VehicleType;Vehicle_MS_BIcom_Vehicle_AutomaticGear;Vehicle_MS_BIcom_Vehicle_Commision;Vehicle_MS_BIcom_Vehicle_PhysicalStockDate;Vehicle_MS_BIcom_Vehicle_DMSVehicleNumber;Vehicle_MS_BIcom_Vehicle_LiveStatus;Vehicle_MS_BIcom_Vehicle_Mileage;Vehicle_MS_BIcom_Vehicle_ModelID;Vehicle_MS_BIcom_Vehicle_EngineSize;Vehicle_MS_BIcom_Vehicle_Active;Vehicle_MS_BIcom_Vehicle_Veh_PreviousRegistrationP;Vehicle_MS_BIcom_Vehicle_ModelLine;Vehicle_MS_BIcom_Vehicle_ConsignmentDate;Vehicle_MS_BIcom_Vehicle_BKVehicleID;Vehicle_MS_BIcom_Vehicle_DMSFuelTypeCode;Vehicle_MS_BIcom_Vehicle_SalesDate;Vehicle_MS_BIcom_Vehicle_VehicleWarrantyExpiryDate;Vehicle_MS_BIcom_Vehicle_BuyingLocation;Vehicle_MS_BIcom_Vehicle_PreviousLastName;Vehicle_MS_BIcom_Vehicle_VehicleStatus;Vehicle_MS_BIcom_Vehicle_FirstInternalInvoiceDate;Vehicle_MS_BIcom_Vehicle_ModelLineID;Vehicle_MS_BIcom_Vehicle_SalesOrderDate;Vehicle_MS_BIcom_Vehicle_PurchOrderType;Vehicle_MS_BIcom_Vehicle_ReservationSalesman;Vehicle_MS_BIcom_Vehicle_DMSTrimCode;Vehicle_MS_BIcom_Vehicle_VehicleGroup;Vehicle_MS_BIcom_Vehicle_AirConditioning;Vehicle_MS_BIcom_Vehicle_CreatingSiteID;Vehicle_MS_BIcom_Vehicle_BookkeepingCode;Vehicle_MS_BIcom_Vehicle_CRMVehicleNumber;Vehicle_MS_BIcom_Vehicle_RegisterNumber;Vehicle_MS_BIcom_Vehicle_EconomicStockDate;Vehicle_MS_BIcom_Vehicle_BuildDate;Vehicle_MS_BIcom_Vehicle_ReservationDate;Vehicle_MS_BIcom_Vehicle_Demo;Vehicle_MS_BIcom_Vehicle_PhysicalLocation;Vehicle_MS_BIcom_Vehicle_WorkshopModel;Vehicle_MS_BIcom_Vehicle_Veh_EngineNumber;Vehicle_MS_BIcom_Vehicle_ModelYear;Vehicle_MS_BIcom_Vehicle_BodyStyleCode;Vehicle_MS_BIcom_Vehicle_InterestFreeExpiryDate;Vehicle_MS_BIcom_Vehicle_MakeID;Vehicle_MS_BIcom_Vehicle_VehicleCreationDate;Vehicle_MS_BIcom_Vehicle_Veh_FinanceAgreementNumbe;Vehicle_MS_BIcom_Vehicle_ArrivalDate;Vehicle_MS_BIcom_Vehicle_VehicleModelGroupCode;Vehicle_MS_BIcom_Vehicle_CompanyVehicle;Vehicle_MS_BIcom_Vehicle_VehicleModelDescription rem Nur in Ziel: Vehicle_ModelID;Vehicle_ChassisNumber;Vehicle_CRMVehicleNumber;Vehicle_VehicleModelGroupCode;Vehicle_WorkshopModel;Vehicle_BuildDate;Vehicle_CompanyVehicle;Vehicle_RegisterNumber;Vehicle_LiveStatus;Vehicle_Make;Vehicle_DeliveryDate;Vehicle_VehicleCreationDate;Vehicle_BookkeepingCode;Vehicle_PreviousLastName;Vehicle_GovermentNumber;Vehicle_Veh_ExtendedWarrantyReferenceCode;Vehicle_VehicleType;Vehicle_AutomaticGear;Vehicle_FirstRegistrationDate;Vehicle_Veh_EngineNumber;Vehicle_ReservationSalesman;Vehicle_DMSFuelTypeCode;Vehicle_PhysicalStockDate;Vehicle_FirstInternalInvoiceDate;Vehicle_ModelLineID;Vehicle_ReservationDate;Vehicle_EngineSize;Vehicle_Model;Vehicle_ConsignmentDate;Vehicle_DMSVehicleNumber;Vehicle_PaymentDate;Vehicle_InterestFreeExpiryDate;Vehicle_BKVehicleID;Vehicle_PurchOrderNumber;Vehicle_PurchOrderType;Vehicle_PhysicalLocation;Vehicle_VehicleGroup;Vehicle_BodyStyleCode;Vehicle_VehicleStatus;Vehicle_CreatingStrategicAreaID;Vehicle_Veh_FinanceAgreementNumber;Vehicle_DMSColorCode;Vehicle_Commision;Vehicle_CreatingDepartmentID;Vehicle_PreviousUsage;Vehicle_Mileage;Vehicle_AlloyWheels;Vehicle_ModelYear;Vehicle_ModelLine;Vehicle_FactoryDeliveryDate;Vehicle_Demo;Vehicle_GoodsReceiptNumber;Vehicle_BuyingLocation;Vehicle_VatTreatment;Vehicle_AirConditioning;Vehicle_SalesDate;Vehicle_DMSTrimCode;Vehicle_Veh_PreviousRegistrationPlace;Vehicle_VehicleWarrantyExpiryDate;Vehicle_WorkshopModelID;Vehicle_BodyStyleDescription;Vehicle_PurchaseOrderdate;Vehicle_ArrivalDate;Vehicle_Active;Vehicle_CreatingSiteID;Vehicle_SalesOrderDate;Vehicle_VehicleModelDescription;Vehicle_MakeID;Vehicle_EconomicStockDate 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_VehicleWarrantyExpiryDate;Vehicle_VehicleModelGroupCode;Vehicle_CompanyVehicle;Vehicle_BuyingLocation;Vehicle_LiveStatus;Vehicle_EngineSize;Vehicle_VehicleModelDescription;Vehicle_GovermentNumber 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_Veh_ExtendedWarrantyRefer;Vehicle_MS_BIcom_Vehicle_AlloyWheels;Vehicle_MS_BIcom_Vehicle_FactoryDeliveryDate;Vehicle_MS_BIcom_Vehicle_ChassisNumber;Vehicle_MS_BIcom_Vehicle_PaymentDate;Vehicle_MS_BIcom_Vehicle_CreatingDepartmentID;Vehicle_MS_BIcom_Vehicle_FirstRegistrationDate;Vehicle_MS_BIcom_Vehicle_Make;Vehicle_MS_BIcom_Vehicle_CreatingStrategicAreaID;Vehicle_MS_BIcom_Vehicle_VatTreatment;Vehicle_MS_BIcom_Vehicle_PreviousUsage;Vehicle_MS_BIcom_Vehicle_DeliveryDate;Vehicle_MS_BIcom_Vehicle_Model;Vehicle_MS_BIcom_Vehicle_PurchOrderNumber;Vehicle_MS_BIcom_Vehicle_DMSColorCode;Vehicle_MS_BIcom_Vehicle_PurchaseOrderdate;Vehicle_MS_BIcom_Vehicle_GoodsReceiptNumber;Vehicle_MS_BIcom_Vehicle_GovermentNumber;Vehicle_MS_BIcom_Vehicle_WorkshopModelID;Vehicle_MS_BIcom_Vehicle_BodyStyleDescription;Vehicle_MS_BIcom_Vehicle_VehicleType;Vehicle_MS_BIcom_Vehicle_AutomaticGear;Vehicle_MS_BIcom_Vehicle_Commision;Vehicle_MS_BIcom_Vehicle_PhysicalStockDate;Vehicle_MS_BIcom_Vehicle_DMSVehicleNumber;Vehicle_MS_BIcom_Vehicle_LiveStatus;Vehicle_MS_BIcom_Vehicle_Mileage;Vehicle_MS_BIcom_Vehicle_ModelID;Vehicle_MS_BIcom_Vehicle_EngineSize;Vehicle_MS_BIcom_Vehicle_Active;Vehicle_MS_BIcom_Vehicle_Veh_PreviousRegistrationP;Vehicle_MS_BIcom_Vehicle_ModelLine;Vehicle_MS_BIcom_Vehicle_ConsignmentDate;Vehicle_MS_BIcom_Vehicle_BKVehicleID;Vehicle_MS_BIcom_Vehicle_DMSFuelTypeCode;Vehicle_MS_BIcom_Vehicle_SalesDate;Vehicle_MS_BIcom_Vehicle_VehicleWarrantyExpiryDate;Vehicle_MS_BIcom_Vehicle_BuyingLocation;Vehicle_MS_BIcom_Vehicle_PreviousLastName;Vehicle_MS_BIcom_Vehicle_VehicleStatus;Vehicle_MS_BIcom_Vehicle_FirstInternalInvoiceDate;Vehicle_MS_BIcom_Vehicle_ModelLineID;Vehicle_MS_BIcom_Vehicle_SalesOrderDate;Vehicle_MS_BIcom_Vehicle_PurchOrderType;Vehicle_MS_BIcom_Vehicle_ReservationSalesman;Vehicle_MS_BIcom_Vehicle_DMSTrimCode;Vehicle_MS_BIcom_Vehicle_VehicleGroup;Vehicle_MS_BIcom_Vehicle_AirConditioning;Vehicle_MS_BIcom_Vehicle_CreatingSiteID;Vehicle_MS_BIcom_Vehicle_BookkeepingCode;Vehicle_MS_BIcom_Vehicle_CRMVehicleNumber;Vehicle_MS_BIcom_Vehicle_RegisterNumber;Vehicle_MS_BIcom_Vehicle_EconomicStockDate;Vehicle_MS_BIcom_Vehicle_BuildDate;Vehicle_MS_BIcom_Vehicle_ReservationDate;Vehicle_MS_BIcom_Vehicle_Demo;Vehicle_MS_BIcom_Vehicle_PhysicalLocation;Vehicle_MS_BIcom_Vehicle_WorkshopModel;Vehicle_MS_BIcom_Vehicle_Veh_EngineNumber;Vehicle_MS_BIcom_Vehicle_ModelYear;Vehicle_MS_BIcom_Vehicle_BodyStyleCode;Vehicle_MS_BIcom_Vehicle_InterestFreeExpiryDate;Vehicle_MS_BIcom_Vehicle_MakeID;Vehicle_MS_BIcom_Vehicle_VehicleCreationDate;Vehicle_MS_BIcom_Vehicle_Veh_FinanceAgreementNumbe;Vehicle_MS_BIcom_Vehicle_ArrivalDate;Vehicle_MS_BIcom_Vehicle_VehicleModelGroupCode;Vehicle_MS_BIcom_Vehicle_CompanyVehicle;Vehicle_MS_BIcom_Vehicle_VehicleModelDescription rem Nur in Ziel: Vehicle_ModelID;Vehicle_ChassisNumber;Vehicle_CRMVehicleNumber;Vehicle_VehicleModelGroupCode;Vehicle_WorkshopModel;Vehicle_BuildDate;Vehicle_CompanyVehicle;Vehicle_RegisterNumber;Vehicle_LiveStatus;Vehicle_Make;Vehicle_DeliveryDate;Vehicle_VehicleCreationDate;Vehicle_BookkeepingCode;Vehicle_PreviousLastName;Vehicle_GovermentNumber;Vehicle_Veh_ExtendedWarrantyReferenceCode;Vehicle_VehicleType;Vehicle_AutomaticGear;Vehicle_FirstRegistrationDate;Vehicle_Veh_EngineNumber;Vehicle_ReservationSalesman;Vehicle_DMSFuelTypeCode;Vehicle_PhysicalStockDate;Vehicle_FirstInternalInvoiceDate;Vehicle_ModelLineID;Vehicle_ReservationDate;Vehicle_EngineSize;Vehicle_Model;Vehicle_ConsignmentDate;Vehicle_DMSVehicleNumber;Vehicle_PaymentDate;Vehicle_InterestFreeExpiryDate;Vehicle_BKVehicleID;Vehicle_PurchOrderNumber;Vehicle_PurchOrderType;Vehicle_PhysicalLocation;Vehicle_VehicleGroup;Vehicle_BodyStyleCode;Vehicle_VehicleStatus;Vehicle_CreatingStrategicAreaID;Vehicle_Veh_FinanceAgreementNumber;Vehicle_DMSColorCode;Vehicle_Commision;Vehicle_CreatingDepartmentID;Vehicle_PreviousUsage;Vehicle_Mileage;Vehicle_AlloyWheels;Vehicle_ModelYear;Vehicle_ModelLine;Vehicle_FactoryDeliveryDate;Vehicle_Demo;Vehicle_GoodsReceiptNumber;Vehicle_BuyingLocation;Vehicle_VatTreatment;Vehicle_AirConditioning;Vehicle_SalesDate;Vehicle_DMSTrimCode;Vehicle_Veh_PreviousRegistrationPlace;Vehicle_VehicleWarrantyExpiryDate;Vehicle_WorkshopModelID;Vehicle_BodyStyleDescription;Vehicle_PurchaseOrderdate;Vehicle_ArrivalDate;Vehicle_Active;Vehicle_CreatingSiteID;Vehicle_SalesOrderDate;Vehicle_VehicleModelDescription;Vehicle_MakeID;Vehicle_EconomicStockDate 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_MenuCodeNumber;SO headr_OHL_CustomerContactOperator;SO headr_OHL_BookedOutOperator;SO headr_OHL_MenuGroup;SO headr_OHL_CreatingOperator;SO headr_OHL_PlannedCheckInDate;SO headr_OHL_BookedInOperator;SO headr_OHL_PlannedCheckOutDate 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]"