SSIS - Using an ASCII character as column delimiters in Flat File Connection Manager -
08-30-2005
, 10:30 AM
Does anybody know how to use any ASCII character as column delimiter in
SSIS Flat File Connection Manager?
I am trying to read from a flat file in which the ASCII character 0x1F
(unit separator) is used as column delimiter, but I don't know how to
enter that non-standard delimiter in the Flat File Connection Manager
Editor. I've tried a few things I coud think of, but without any luck.
Any ideas? |