Thanks for the quick and simple overview of how to use BCP with xp_cmdshell from within an SP.

Question: Are there any options to delimit text values? I'd like to use BCP to produce 'csv' files, however some of my data has commas and line-feeds/carriage-returns in it: I'd need to double-quote data those values...

Thanks,

Mark