

“CODE1","My Description Field ""My Embedded, Description"" ",5590214

Hope this helps !!

Sudeep

Hi Kieran,The issue here is that in the Description column you are having comma which is being used as the column delimiter.SSIS will split the column where ever it gets the comma.You have 2 options:1. Its tough that u dont have control over the source data, could you get the delimiter changed to pipe"|" as it is not generally used in description.2. If you have some logic to split the description field you can use script component to break the record as per ur need.As i see, you string columns are having double quotes and if there is an inner comment it again starts with another double quotes(is it consistent?)If yes you can have the logic to get the 1st column based on 1st occurrence of comma.For next column check for opening quotes, continue till you find the closing quote, if the next char is not a quote this is ur 2nd column else continue till you find single closing quote(ignore commas here).Once the above step is complete get the next column value for what ever is after the comma.ORAnother simple logic would be:get the position of the 1st comma and take all the value before it as the 1st column.get the position of the last comma and all the data after it goes to the last column.and then all the data between the above 2 positions will be ur 2nd columnLet me know if this sounds feasible.If possible I would still suggest to get the source data changed with a different column separator.