Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2012-02-21 : 03:57:10
|
| Hi,We have to load data from table to csv file using ssis.The data in the datebase has values with commas. Eg. Company name Inc,. Plc,. etcHow do we byepass the commas from the database fields.Thanks in advance.- Varalakshmi |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-02-21 : 04:12:57
|
Use " around column values.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2012-02-21 : 04:34:48
|
| Thanks for the reply.Some column values will have comma in it and other values of the same column do not have commas. Can you please explain briefly how this could be handled- Varalakshmi |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2012-02-21 : 06:26:55
|
| If you do as Peso suggested a comma in the middle of a column will be ignored-----------What color do you want that database? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-21 : 14:38:48
|
quote:
Originally posted by varalakshmi
Thanks for the reply.Some column values will have comma in it and other values of the same column do not have commas. Can you please explain briefly how this could be handled- Varalakshmi
then you need to apply expressions to replace commas with blank values. Or if you want a set based solution dump it in staging area, fire an update to replace the commas and then do final population into your destination------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
commas in csv file