A similar article i wrote about re-naming the columns with double quotes HERE

Here is an example of what i want to say..

all of my columns contain Double Quotes in this example and i want to get rid of the double quotes at once.

USE <DatabaseName>

select ‘update SQLServerLifecycle set ['+column_name+']=replace(['+column_name+'],’+””+’"’+””+’,'+””+””+’)’
from information_Schema.columns where table_name =’SQLServerLifecycle’

To see all the query List colors:

Get the results in TEXT (Or Not its your choice)

Copy the Result and Paste in New Query window and Execute. (By Gods Grace, everything will work out fine)

You can also search for articles based on SSIS, which can do that during the Load of the information.