November 8, 2009 at 11:04 am
Hi All,
I am having problems loading a comma delimited, .CSV file into SSIS. The flat file connection Manager thinks there are 13 rather than 14 columns as the final column is empty in nearly all cases I think. There is also no ‘Header row’ in the CSV file.
The error message the flat file connection shows is "the last row in the sampled data is incomplete. The column or the row delimiter may be missing or the text is qualified incorrectly."
If I place a zero in the last row of the file I do not receive an error message, however this is not an option in the source system generating the .CSV file.
The final column has been set with a Column Delimiter of ‘{CR}{LF}’ rather than Comma.
An example couple of row of data as follows;
field1data;field2data;field3data;field4data;;;;field5data;;;;;;;
field1data;field2data;field3data;field4data;;;;field5data;;;;;;;
I would be really greatful if anyone could assist me in loading this file into SSIS.
Regards,
Chris
November 9, 2009 at 4:46 am
You need to change the extended properties on your Excel connection - as a default excel will check the first 8 (ish) rows of data to guess datatype etc.
http://msdn.microsoft.com/en-us/library/ms141683.aspx
http://ganeshprof.blogspot.com/2007/10/excel-connection-in-ssis.html
November 10, 2009 at 10:23 am
Hi Chris,
Many thanks for your suggestion. This solved my issue by changing the value from '6' to '16'.
Regards,
Chris
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply