All,
I went through about a week of research to figure how to import files with DTS. Come to find out these files are from unix and row delimited with a leed feed character only. They are row-delimited this way because they were ftp-ed from unix under the binary transfer mode. If you ftp them under ascii mode, you get row delimiters that everything in the windows world can read and understand.
DTS expects a carriage return plus a line feed. They are chr(10) and chr(13) in windows. In unix, you only get chr(10) if you ftp in binary mode.
-Tom

DTS can import files with any row delimiter like care to mention, except
maybe a null character. So it can quite happily use Cr or Lf or C+Lf as a
delimiter.

The GUI itself has options to select "{CR}{LF}", "{CR}" and "{LF}" amongst
others.


--
Darren Green
http://www.sqldts.com

"TomTait747" <TomTait747 (AT) discussions (DOT) microsoft.com> wrote

delimited with a leed feed character only. They are row-delimited this way
because they were ftp-ed from unix under the binary transfer mode. If you
ftp them under ascii mode, you get row delimiters that everything in the
windows world can read and understand.
mode.