What datatype has the FirstName column in SSIS? And especially, what length?
And what is the datatype in the destination? Check the flat file connection manager to find out.
What is the encoding of the flat file?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP