SSIS package failing with unclear errors including error with the source

Executed as user: SLX\slx-prd-mssql-svc. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4083.2 for 32-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 9:42:08 AM Error: 2022-09-07 09:42:11.10 Code: 0xC020901C Source: Load data from K**** to transit server employee Source [424]
Description: There was an error with employee Source.Outputs[OLE DB Source Output].Columns[emp_name] on employee Source.Outputs[OLE DB Source Output]. The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". End Error Error: 2022-09-07 09:42:11.10 Code: 0xC020902A S ource: Load data from Kodiak to transit server employee Source [424] Description: The "employee Source.Outputs[OLE DB Source Output] .Columns[emp_name]" failed because truncation occurred, and the truncation row disposition on "employee Source.Outputs[OLE DB Source Output] .Columns[emp_name]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. End Error Error: 2022-09-07 09:42:11.10 Code: 0xC0047038 Source: Load data from K**** to transit server SSIS.Pipeline Description: SSIS Error Co de DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on employee Source returned error code 0xC020902A. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error Error: 2022-09-07 09:42:11.52
ode: 0xC02020C4 Source: Load data from K**** to transit server census_organization Source [47] Description: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. End Error Error: 2022-09-07 09:42:11.52 Code: 0xC0047038 Source: Load data from Kodiak to transit server SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on census_organization Source returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:42:08 AM Finished: 9:42:11 AM Elapsed: 3.438 seconds. The package execution failed. The step failed.