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

avatar image

174 26 27 30

(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

avatar image

Daniel Ross
2.9k 11 15 18

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.

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: 1428 times

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

Copyright 2018 Redgate Software. Privacy Policy