asked
SSIS Data Flow Task Source as Tabbed Delimited File not reading last line throws partial data on last line error
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.
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.
when i executed the same package from another server it worked fine. dont know whats missing on my machine
