I've tried many things.

Like deleing the destination and source components again.

Check/uncheck the first column is data column

Even when I tried to export the table from SQL server, it does not...

Hello Phil,

Seems like you are trying to tell the following solution.

http://visakhm.blogspot.in/2014/06/ssis-tips-handling-embedded-text.html

Actually I tried to achieve it but the replace expression is throwing an error. It does not allow...