It would be hard for me to share the package and file because it is dealing with Employee data.

The package has a Data Flow Task which contains only three transformations:

OLE DB Source - which selects the data using a SQL query

OLE DB Destination - which inserts the data into the destination database table with Error Output set to "Redirect row"

Flat File Destination - which is a tab delimited file to capture the error records

Also the key for the Destination table is:

EmployeeId

OfficeId

EffectiveDatetime