Menu
I need to escape quotation marks in SQL Server Integration Services' Expression Builder. I cannot escape it with double or triple quotes.
716
SSIS Expression Builder Expression builder is a tool which helps us build an expression. This tool can be invoked from the expression property of a Task or Container. Also, this tool is available for the conditional split transformation and derived column transformation.
In ANSI SQL, the backslash character (\) is the escape character.
really helped, simple enough ,just place "\" before " to use in SSIS expressions.
In SSIS, variables can't be set to NULL. Instead, each variable data type maintains a default value in the absence of a value.
Backslash "\" is the escape character.
Example: "SELECT branch, \"tran-date\" FROM TellerTransaction"
172
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
