What is the escape character for SSIS Expression Builder?

sql-server ssis expressionbuilder
M. Travis Volker picture M. Travis Volker · Feb 12, 2010 · Viewed 31.4k times · Source

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

Answer

M. Travis Volker picture M. Travis Volker · Feb 12, 2010

Backslash "\" is the escape character.

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

Related questions

'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.Data) It is not the same …

Read More
Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

I'm trying to import a flat file into an oledb target sql server database. here's the field that's giving me trouble: here are the properties of that flat file connection, specifically the field: here's the error message: [Source - 18942979103_txt [424]] …

Read More
How do I fix the multiple-step OLE DB operation errors in SSIS?

I'm attempting to make a DTS package to transfer data between two databases on the same server and I'm getting the following errors. Iv read that the Multiple-step OLE DB operation generated error can occur when you are transferring between …

Read More