Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 716
M. Travis Volker Avatar asked Feb 12 '10 21:02

M. Travis Volker


People also ask

What is expression builder in SSIS?

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.

What is SQL escape character?

In ANSI SQL, the backslash character (\) is the escape character.

How do you use double quotes in SSIS?

really helped, simple enough ,just place "\" before " to use in SSIS expressions.

IS NULL expression in SSIS?

In SSIS, variables can't be set to NULL. Instead, each variable data type maintains a default value in the absence of a value.


1 Answers

Backslash "\" is the escape character.

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

like image 172
M. Travis Volker Avatar answered Sep 19 '22 11:09

M. Travis Volker