I have a simple csv file with addresses to import to sql table. There are comma inside the string, such as name= 'Mycompany, Inc'. normally from DTS it is OK. But when run bulk insert it separated to two columns.
how to identify the inside comma from delimiter? I have no control to change the file format or content.