In case your SSIS package fails to insert new records into a destination table and you receive an error message like:
No status is available.
In my case, the Error Description (custom) component returned this message and wrote it to my errors-table:
More info about this component can be found here.
It’s probably a Foreign Key (FK) constraint, you might want to check those.