Hi @Landon S,
Please first make sure that the data type is matched between the two tables.
You can create a second OLE DB Destination and direct the red arrow from your Data Conversion task to this destination. Then choose Configure Error Output in your Data Conversion task and choose Redirect row as an option for all Errors/Truncations. So that you could see if the rest rows is in the error output.
In addition, you may re-create a package and then re-add the component for a try.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.