How to embed quotes in t-sql

[joel84]

I have copied some text to Notepad file and found that it has comma-delimited, file with the double quote (") is used as the text qualifier. I also had an little vbscript that uses the FSO to write a T-SQL text file to a folder. import this file into a table using SQL Server 2005, so I am using SSIS. However, there are 2 columns in this file which have embedded in its text, quotes, of all characters. Now my requirement is that it should allowed me to embed quotes to the sql statement.

[Alejandro]

If you're doing string manipulation in T-SQL, you'll frequently stumble upon tasks that require you to embed single quotes in your queries. Single quotes poses a problem when building SQL on the fly in TSQL scripts. The problem is, the single quote is what is used to enclose strings in T-SQL. This is because single quotes are used to enclose strings in TSQL.

[Vitus]

The Windows Script Host (WSH) runtime engine reads a script's command-line arguments and makes them accessible in the WshArguments object and its associated collections. A concatenation operator to separate the first part of the sentence and the one that comes after the single-quote and the use of a two-single quote approach.

[Khushal]

SSIS is choking on the embedded quotes. Is there ANY way around this? This seems like it should be a bug in SSIS. Two single quotes look like a double quote. And if you have double quotes in your sql, it will be very confusing. I could swear that I used to be able to do this with DTS and in Excel and Access too. This simpy means that every time you have a single-quote character included in your string, you have to do string concatenation to accomodate the insertion of a single-qoute in your string.