BackT0Work (4/19/2011)

---

my SSIS package loads data from excel file to SQL server table. The excel file has 5000 rows.

When I execute the Package the number of rows shown in the data flow path is 5000 leading to oledb destination. No errors. everything in green.
But when I check the sql table record count its only 100.
(Note: I have used - table or view - Fast Load. I have error output redirected to another table. Nothing is entered there as error.)

when I delete oledb destn and place Flat file destintion, all 5000 records are loaded.

When I create a new table(SSIS defined) from oledb destn, instead of original table, all 5000 rows are loaded. Again if I rename this new table to original table it loads only 100 rows.

The original table doesnt have any triggers/constraints.

What might be happening here?

Thanks.

Darren Lesnever (1/15/2013)

---

Make sure you don't have the error output for the OLE DB destination set to ignore errors.