bcp script

@echo off
@set hostName=nnn.nam.nsroot.net
@set dbName=_TEST
@set portNum=2431
@set userName=gic
@set password=gic


REM bcp database_name.owner.table_name in datafile_name -c -t'|' -Usa -Ppwd -Ssybsrv -b5000
echo load start
 

for %%f in (*.csv) do (
  for /F "delims=. tokens=1" %%i in ("%%f")do (
    echo %%i
    call :load %%i
  )
)
goto :done


 

:load
echo %time%
echo start to load %1.csv under %cd% >>load_delta01.log
echo ------------------------%1 start at %time%-------------------------
REM bcp %dbName%..%1 in %cd%\%1.csv  -f %cd%\%1.fmt  -F 2 -b 10000  -S%hostName%,%portNum% -U%userName% -P%password% >>load_delta01.log
REM bcp %dbName%..%1 in %cd%\%1.csv  -t '|' -F 2 -b 10000 -S%hostName%,%portNum% -U%userName% -P%password% >>load_delta01.log
bcp %dbName%..%1 in %cd%\%1.csv  -f %cd%\%1.fmt  -F 2 -b 10000   -S%hostName%,%portNum% -U%userName% -P%password% >>load_delta01.log
echo %time%
goto :eof


:done
echo load complete
pause

REM EXECUTE master..xp_cmdshell 'E:\Mssql\Binn\BCP pubs..authors out C:\authors.txt /c /Sservername /T -n -t "|" '