0

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.

Improve this question

1 Answer 1

Reset to default
1

You are looking for the "Text qualifier" option of the Flat File Connection Manager. As you can see in the image below, the default value is <none>, but you will change it to " to have your expected output.

enter image description here

By doing that, SSIS will add the character defined as a Text qualifier at the beginning and end of your string columns.

If you need to have a column without the Text qualifier (""), then you can change the option Text Qualified to False on the Advanced menu of the column. By default, this option is set to True. enter image description here

More details can be found on Flat File Connection Manager

Improve this answer
2
  • Hmm, the settings on the package already match this.
    – ServerMonkey
    Commented Aug 2, 2020 at 23:50
  • Have you changed the Text Qualifier from <none> to " ? (As described, not like the picture)
    – Evandro
    Commented Aug 3, 2020 at 6:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.