I have some developers who want to create .xlsx files from SQL Server.
There is a claim that it necessary for me to install excel on the server in order for this to work.
Is this standard practice? They are running an SSIS package to create the files.
I think there is a c# solution that you can add with a script task to avoid installing the actual application to a server and all you would need would be this driver package.
http://www.microsoft.com/en-us/downl....aspx?id=13255
The server is always under a lot of memory pressure because it's mainly used for data warehousing and they also built a cube on that server. So I am hoping to avoid this.
Any feedback would help. Thanks.