Search code examples
ssisflat-filequalifiers

How to assign a text qualifier in a flat file destination?

We have an SSIS package which reads from a DB, creates a flat file from that info, and drops it to a file server.

I recently made an update to the package's query which is used against the DB, adjusted the column mappings, and placed it under the SQL Job which ran the SSIS package before.

The problem is that the text qualifier in the flat file should be a quotation mark: ". But when I checked the flat file it produced, the text qualifier showing is: _x0022_

I investigated the Text Qualifier property for the DestinationConnectionFlatFile, and it is set to a quotation mark: "

How can I ensure the flat file will have a text qualifier of quotation mark?

Solution

  • Here is a previous answer I found when this happened to me:

    SSIS exporting data to flat file renders double quotes as hexadecimal characters