SSIS FTP Task Editor

• downes

  SSC Eights!

  Points: 840

  More actions

  October 20, 2009 at 1:20 pm

  #212231

  Source system creates .txt file

  007 scr

  008 scp

  009 kve

  Row delimiter {CR}{LF}

  Column delimiter Tab {t}

  I'm using a FTP task to move the txt files (/fl1st/dwh3/*.txt) to the sql server.

  When I open the txt file via notepad++ it now contains a extra {CR}.

  example: 007{t}scr{CR}{CR}{LF}

  I imported the data via flat file which also moved the extra {CR} as part of the column. I have several hundred txt files I have to load.

  Does anyone know why the extra {CR} is being added?:unsure:

• downes

  SSC Eights!

  Points: 840

  More actions

  October 20, 2009 at 3:06 pm

  #1068543

  Found the issue.

  The source system was converting the text files to a dos format (need this for sql2000 not sql2008).

  We removed the unix to dos conversion and the extra {CR} is gone.:w00t: