Hi,

I am working on DTS package on MS SQL 2005 Ent/Windows 2003. The package FTP a text file into SQL site. The original file in FTP side has "|" as the column delimiter and rows were line up correctly. After FTP task and copied over to SQL server side, although it still has "|" column delimiter, but row delimiter became "|" (or "I" followed by square like). All lines ran into one.

Is there a way I could break lines? Many thanks.

Chris