The SQL task is missing task documentation for the delimitertype attribute.
Here is my contribution to that effort: delimitertype The delimiter type indicating whether the delimiter will only be recognized on a line by itself. Default is "normal" which means the delimiter is recognized at any location in the line. "row" meand the delimiter is only recognized on a line by itself.