Hi All,

How can I add the date/time stamp to the end of the text file? This file is being created as a result of query output of the bcp command:

'bcp "Select * from ##Test" queryout C:\Test\JobForDB.txt -S servername -U user -P password -c'

I need to add date/time stamp to the JobForDB.txt file before the period.

Thanks