Hi
I use bulk insert to load data from a csv file to sql server db. The
character data in the file is surrounded with quotes. In the bulk task I
have given the duoble quotes as the Text Qualifier. But when the data is
loaded it loads with the double quotes.

Any suggestion as to why its happening?
thanks
Alroy

OK

I thought I answered this one but it seems not to have
appeared so here goes again.

Couple of options

1. Format file (Examples on Google)
2. Do a REPLACE() on the after post import.