We do a lot of file imports and exports. One thing that really helps is to add a last update column to your staging table. We've had many cases where the package did not send an email error notice when it failed. By looking at the staging table update column we can quickly see if the data processed or not.