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.