Hi,
This is an urgent request. Any input would be highly appreciated.

I am trying to bcp data from a table into a flat file. (I will be setting this up as a scheduled task that runs nightly.) How can I bcp data into a flat file in a particular folder/directory of my choice. Is this do-able. If so, how?

Please let me know
Thanks
Kiran