Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SSIS flat file source
Message
De
25/05/2012 08:55:05
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Business Intelligence
Divers
Thread ID:
01544379
Message ID:
01544392
Vues:
22
Thanks Sergey.

I'll check for that

>Whe you create flat file source, go into Advanced tab and delete the last column. Keep in mind that values of the extra column will go into the previous column including column separator.
>>
>> I'm trying to import a csv using a flat file source in a dataflow package.
>>
>>Some of the lines in the text have an extra column at the end but not all.
>>
>>This was causing my import to fail.
>>
>>I've tried removing that column from the flat file source as I can igore it but I'm still getting an error.
>>
>>[Flat File Source [1]] Error: The column delimiter for column "SPONSORSHIP" was not found.
>>
>>
>>Any ideas ?
>>
>>Thanks
>>
>>Nick
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform