Hi,
We have a series of CSV files which contain a comment field. This is free-form text, and thus can contain new lines, etc..
Our legacy solution (base on SSIS) can't handle that, so a script removes the newlines. Do we need to do this with Data Services ? The fields are quoted, so will DS continue onto the next line looking for the end of the field ?
It would be preferable to preserve the newlines, as sometimes it is significant.
Secondly, every field in quoted in the file including the header line. When I set the text delimiter, it works for the records, but not for the header. The only way I have found to fix this is to manually edit the headers. Is there another way to do this ?
Thanks.