Following is sample from my application
Source- Tabbed Delimited file Col1 Col2 Col2 aa a 1 2 da a 1 2 ca a 1 2 ba a 1 2
Destination- OLE DB Table
create table test_data_1 (col1 varchar(100), col2 int, col3 varchar(100))
Issue- all the rows are copied Except the last Row, when check debug file, there is a warning saying last line has Partial data hence ignored.
Any suggestions on how to fix this issue in SSIS?
Data is valid data.
asked Jan 08 '12 at 09:58 AM in Default
Say the Tabbed document has 3 columns, therefore 2 tabs on each row, SSIS expects there to be 2 tabs on each row otherwise it will ignore the row. Try opening the file and manually enter the tabs yourself, if the tabs are missing then you could try and get the file fixed at the source, or you could always create a script component as the source.
answered Jan 08 '12 at 09:24 PM