The actual error most likely has the column name in it, and that's the one you should investigate.
What is the length in the source? What is the length in the destination?
What is the data type in the SSIS data flow?
At which component do you get this error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP