store file prirefix with date value.

[ravi]

Hi,
I need to export data from sql server into flat file. The file sould be generated with current date and table anem.

for example yyyymmddhhmmsstablename.txt.

Do you have any solution for this.
Thanks,

[skhanal]

I suppose you want to automate it. You can write a T-SQL Script to get filename with current date time and generate a xp_cmdshell command with bcp out to the file name and run with EXEC.

exec (@your_xp_cmdshell_bcp_out)