>>Hi
>>
>>I'm importing data from a web site in a SSIS package via a csv file.
>>
>>An new supplier uis sedning files where the csv lines and with a small square and fail to import properly.
>>
>>In a hex editor the lines end with 0a
>>
>>in files which import successfully the files lines end with 0d 0a
>>
>>As I am not having much success getting the web site to provide the correct end character how can I make my SSIS import more tolerant of different line formats and import this format.
>>
>>Thanks
>
>0A is a linefeed character (as compared to 0D 0A which is normal carriage return/linefeed combination).

Thanks William. I knew that bit.

Any ideas on how I can make my dataflow import less dependant on the end of line character ?


Nick