Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 There is a partial row at the end of the file

Author  Topic 

Babli
Yak Posting Veteran

53 Posts

Posted - 2008-12-09 : 09:02:17
Hi,
I am trying to import a file with semicolon seperated values into a table.Though the package runs successfuly no row is imported into the table.All i get is a warning "There is a partial row at the end of the file".

I tried importint the same file into table using the Import\Export wizard in sql 2005.Here though its saying as the package is successful the no of rows imported is zero.

So my question is is this a prob with the file or the ssis package?What to do so that the data gets into the table?

Please help.......

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-09 : 13:32:35
seems like you've non completed row in file or you've ; coming in between data too.
Go to Top of Page
   

- Advertisement -