Wednesday, December 29, 2010

Batch to move the file out

Send out file :

FOR /F "tokens=1-4 delims=/ " %%i IN ('DATE /T') DO SET TODAY=%%l%%j%%k

SET OUTFILE=\\WTPCPFTGT001\ftp_itg$\G-TRADE_EXEC_%TODAY%.csv

osql -S wtpcpdb1 -E -w 4000 -Q "exec gpro..ITG_Canada_EXEC" -o %OUTFILE%

No comments:

Post a Comment