Add Special Charachter In Ssis Flat File Column Header

I am generating a Flat file from OLEDB Source using SSIS. I have specified column headers and mapped them with source columns but SSIS automatically remove special character like '

Solution 1:

You can add special characters to Flat File Header as the following:

• Add a flat file connection manager
• At the flat file connection manager editor, Go to advanced Tab and rename your column

Remark: these special characters will be ignored when using SSIS objects like Script Component