I am generating a file name based in current date and sequence number depending in how many files have been generated in the current date. Along with the current date in the file name also I am add...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23231820.html