As I have to install this on a production environment, I want to be sure of certain things ...
Say I have installed the Provider, what would be the syntax for exporting the data from sql server 2014 to xls.
I would recommend that you first install the provider in a test environment and try to get things working there first, so that you have syntax and configuration correct.
It may still fail in production due to permissions etc, but then you would know what ghost you are chasing.
Or start looking for a less invasing solution. For instance, using the Export/Import Wizard in SSMS, or write an SSIS package. (No, I don't know SSIS myself, but you need to start somewhere.)
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment