Yes, I wish to export some 10 columns, of which we have a column that contains HTML content.

I can take all the columns as enclosed in " " by concatenating...

Hi Jeff,

The post is very useful. Am actually trying to perform something similar. Trying to export data to a csv file. I have a column which will hold html text...

thank you for the reply.

I again have tried couple of options. It seems OPENROWSET feature is designed more for imports than exports. Currently am trying to build SSIS packages to...

I tried with ';' after MSDASQL and then comes the error 'The OLE DB provider "MSDASQL;" has not been registered.' which is exactly what you ve doubted. Need to...

Hii

Yes I have set 'Ad Hoc Distributed Queries' to 1. Actually I have used the OPENROWSET with similar syntax to load data into table.

And the file name is...