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