| 1234567 |
- @call "%~dp0config2.bat"
- rem %1 = CSV-Dateiname [ohne Endung]
- rem %2 = SQL-Query
- bcp.exe %2 queryout "%SQL_TEMP:~1,-1%\%~1.csv" -S %SOURCE_SERVER% -d %SOURCE_DATABASE% -U %SOURCE_USER% -P %SOURCE_PASSWORD% -c -C 65001 -m 1000 -b 2000 -e "%SQL_LOGS:~1,-1%\%~1.queryout.log" > "%SQL_LOGS:~1,-1%\%~1.bcp1.log"
- rem echo %2
- rem type "%SQL_LOGS%\%1.bcp2.log" | findstr -v "1000"
|
