sql server – SSIS Import .csv


I’m new to SSIS and I’ve got an existing SSIS task which is importing a CSV file that has some unusual formatting.

The CSV has formatting like this:

TaskID, TaskName
ABC,Test Entry ABCD,Test’s Complete

The format of the file needs to change to:

TaskID, TaskName
ABC,Test Entry ABCD,”Test’s Complete”

Looking for some general advice as to how that change can be made, I don’t see anything obvious in the connection Manager to do this.

Thanks in advance.