Thursday, February 17, 2011

Simple Batch Script Example to send the file


Simple Batch Script  Example to send the 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 "execgpro..ITG_Canada_EXEC" -o %OUTFILE%

No comments:

Post a Comment