Problem in inserting data from Excel to database

Question

I am using SSIS to insert data from Excel 2007 to SQL Server database, but i am not able to insert all the rows present in Excel. Suppose My Excel is having 2000 rows but only 1500 rows are inserting in DB,while Package is showing as successfully completed.

Answer 1

You can give IMEX=1 property in Excel connection manager property window. Sometime some values in string format does not goes properly so you can you this property.