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.

more ▼

asked Jan 08, 2012 at 09:58 AM in Default

pvsrinivasrao gravatar image

174 26 27 27

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
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.
more ▼

answered Jan 08, 2012 at 09:24 PM

Daniel Ross gravatar image

Daniel Ross
2.9k 11 13 14

when i executed the same package from another server it worked fine. dont know whats missing on my machine
Jan 09, 2012 at 02:07 AM pvsrinivasrao
is it exactly the same file you are trying to import?
Jan 09, 2012 at 06:40 PM Daniel Ross
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 08, 2012 at 09:58 AM

Seen: 1168 times

Last Updated: Jan 08, 2012 at 09:58 AM