Start by adding a data viewer in the Data Flow Task, between the Flat File Source and the destination.

Run the package in debug, if all the rows are shown in the Data viewer, then the problem is at the destination, otherwise at the source.

😎