sql server dts: 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.

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

[quoted text, click to view]
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.
[quoted text, click to view]
chr(13) in windows. In unix, you only get chr(10) if you ftp in binary
mode.
[quoted text, click to view]