How to remove double quote when import data into SQL Server from flat csv file?

Set Text qualifier to  double quote.

Reference:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/923b39ef-bb91-430a-8791-f538870cffdd/how-to-remove-quotations-from-import-flat-file?forum=sqlintegrationservices