patternMinor
SSIS flat file manager - skips the last record
Viewed 0 times
lastfilethessisskipsflatrecordmanager
Problem
I've a a flat file which is pipe delimited as shown below:
When I create a package on a 64 bit machine it always drops the last record. But on preview it shows both records.
Update:
If I do this it works:
Why is this and how do I fix it?
header|header2
abc|abcdef
abc|abcdefWhen I create a package on a 64 bit machine it always drops the last record. But on preview it shows both records.
Update:
If I do this it works:
header|header2
abc|abcdef
abc|abcdef
|Why is this and how do I fix it?
Solution
I had the same problem on Windows Server 2008 R2 x64. A flat file source would not load the last record... So this answer helped me, and now it's working fine.
Go to advanced column view, select all the columns and set the text qualification drop down to
Go to advanced column view, select all the columns and set the text qualification drop down to
false for all the columns.Context
StackExchange Database Administrators Q#6132, answer score: 5
Revisions (0)
No revisions yet.