UnDouble takes a text column, and, removes bracketing quotes if present, plus replaces double quotes inside the text with sinqle quotes.
SQL Server SSIS Sample Component: UnDouble
SQL Server SSIS Sample Component: UnDouble