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