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.
Bookmarks