Here is the one Data from my source is erroring out.
"E:60 Pic: 20 years and 11 seconds" - The Travis Loy Story"",
The source file is in .csv format and In SSIS Flat file source I am using TEXT QUALIFIER = ". He is removing first " in the source file but the second one. If I remove second double quote (")
from the file, it is working. Any advice how can I fix this issue?