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.
Thanks for helping out. I am using File Transfer Protocol Task to a source file then to a staging. Tried to define cinnection between source file and staging (or source and destination). Used ANSI file type, {CR}{LF} (and other types) for row delimiter, none for text qualifer..., however, it does not take the row delmiter. I attached a copy of screen shot. Noticed there is "|" and square before USA on the second line.
Is there way to convert the file before uploading? Thanks.
Reply With Quote