Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data import
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Business Intelligence
Titre:
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01556615
Message ID:
01556702
Vues:
41
>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).
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform