sql-serverssisexpressionbuilder

What is the escape character for SSIS Expression Builder?


I need to escape quotation marks in SQL Server Integration Services' Expression Builder. I cannot escape it with double or triple quotes.


Solution

  • Backslash "\" is the escape character.

    Example: "SELECT branch, \"tran-date\" FROM TellerTransaction"