General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Hi Charles
I did try that but it didn't seem to kick in. I'll give it another shot.
>This is theoretical and kludgy but might trigger some better thoughts:
>You can redirect rows that fail. Suppose you redirect all the short rows to another table structured that way but with a data transform to add a blank column and then send the result to the table the longs rows were imported to.
>
>>Hi
>>
>> 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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only