|
|
|
Mr or Mrs. 500
 
Group: General Forum Members
Last Login: Wednesday, December 09, 2009 1:56 AM
Points: 544,
Visits: 49
|
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 668,
Visits: 1,339
|
|
Good article. One suggestion would be to use the pipe character ( | ) as the default separator. Some people and place names have embedded commas. Some countries use commas as decimal separators.
Keep up the good work. Nice job.
ATB
Charles Kincaid
|
|
|
|
|
Valued Member
Group: General Forum Members
Last Login: Wednesday, February 24, 2010 11:45 AM
Points: 55,
Visits: 2,246
|
|
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
Mark
Just a cog in the wheel.
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, December 09, 2009 1:56 AM
Points: 544,
Visits: 49
|
|
Hi Mark,
There is no option available in bcp to delimit the some field value into double-quote but you can you double-quote for all the field values.
Thanks
Manish Mathur
|
|
|
|
|
Valued Member
Group: General Forum Members
Last Login: Wednesday, February 24, 2010 11:45 AM
Points: 55,
Visits: 2,246
|
|
manish.mathur (2/15/2009)
Hi Mark,
There is no option available in bcp to delimit the some field value into double-quote but you can you double-quote for all the field values.
Thanks
Manish Mathur
Yeah, that's what I thought.. Oh well.
Thanks for the reply!!
Mark
Mark
Just a cog in the wheel.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, February 23, 2010 5:45 AM
Points: 3,
Visits: 31
|
|
I am running the procedure and getting error:
SQLState = S0002, NativeError = 208
Error = [Microsoft][SQL Native Client][SQL Server]Invalid object name 'EMS.dbo.tblBilling'.
SQLState = 37000, NativeError = 8180
Error = [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.
Please guide
Regards:
Abdul Rahman
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 20, 2009 10:22 AM
Points: 3,
Visits: 8
|
|
There is no option available in bcp to delimit the some field value into double-quote but you can you double-quote for all the field values.
Hi There, in your post you mentioned that there is a way to double quote all fields in BCP, could you tell me how to achieve this please, as I am struggling to find anywhere that tells me.
cheers
|
|
|
|
