| 1234567 |
- @call "%~dp0config2.bat"
- rem %1 = CSV-Dateiname [ohne Endung]
- rem %2 = SQL-Query
- rem %3 = Datenbank
- bcp.exe %2 in "%SYSTEM_DIR:~1,-1%\Export\%~n1.csv" -f "%SYSTEM_DIR:~1,-1%\Export\Format\%~n1.csv.xml" -S %DEST_SERVER% -d %3 -U %DEST_USER% -P %DEST_PASSWORD% -C 65001 -m 1000 -b 2000 -h TABLOCK -e "%SQL_LOGS:~1,-1%\%~n1.in_fmt.log" > "%SQL_LOGS:~1,-1%\%~n1.bcp3.log"
- rem type "%SQL_LOGS%\%1.bcp3.log" | findstr -v "2000"
|
