SQL 2008 SSIS Question - How to insert a double quote.

[Lockhouse]

I don't usually post in this forum but I've got a quick SSIS question that I can't figure out.

I'm doing an SSIS data transform from an ADO.Net connection to a flat file and I'm using the Derived Column Transformation Editor to reformat a field. How do I insert a " (double quote) into the reformatted field? I can't seem to find any protection characters (""" or / etc) and there is no CHR function available so I can't use CHR(034). So how's it done?

For example - I want the field to look like ""345"" when transformed including the quotes.

Cheers

[Weltchy]

[Field A] + "\"" + [Field B]

Or for your example

"\"\"" + [Field with 345 as value] + "\"\""

[Lockhouse]

[Field A] + "\"" + [Field B]

Or for your example

"\"\"" + [Field with 345 as value] + "\"\""

Thank you that man.