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.