Have come across a strange scenario and seeking your ideas/thoughts.
I'm using a ssis package to load a txt file. The txt file is text delimited by double quote (") and column delimited by tilde (~). It works fine in most scenarios and strips the enclosing "" from the columns -no problems there. However, in a specific
scenario where the last column has double quote in the data as well being the text delimiter, the package throws the following exception indicating that it's missing a column delimiter
The column delimiter for column "COL_NAME" was not found
This behaviour was not observed when double quotes were present as data in any other column in the file. Was able to workaround by disabled text delimiter only for the last column, but that isn't a perm solution. Also observed that if the " was replaced
by escape sequence /" the file loaded successfully. Wondering if this a known issue ?
View Complete Post