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