I am trying to import a csv file that has a text qualifier of " and a column delimiter of comma. There are also commas within some of the data of the field. For example, "Fred Willam Shop, Inc.". When I try to use SQL Server 2000 DTS import wizard to import the file specifiying that it has a text qualifier of " and a delimiter of comma it gives the error below:
Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
Error Description: Invalid delimited data: text qualifier must be followed by a column delimiter(except the last column).
Context: Error calling OpenRowSet on the provider.
Has anyone run into this? Is there a fix for it or should I have the supplier of the file change the column delimiter to tab delimited?