I tried with a file having the folllowing content.

"Jacob","jacob"s" File", "Other File"

I get this file processed correctly (Jacob, Jacob"s" File, Other File) with the following settings (SSIS Flat File Connection manager)

format: delimited

Text Qualifier: "

Column delimiter: comma {,}

Row delimiter: {CR}{LF}