Information générale
Forum:
Microsoft SQL Server
Catégorie:
Business Intelligence
Versions des environnements
SQL Server:
SQL Server 2008
>>>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 ?
Can you just modify the file to replace all 0a with 0d0a before importing ?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement