Click here to Skip to main content
14,735,239 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am having a SSIS script task from which I have written some logic to write sql query results to excel file.I am using the connecting string as Provider=Microsoft.ACE.OLEDB.12.0,but again it is asking to install Microsoft office access database engine 2007 which is not allowed to download and install in my server due to some licence issue.If any alternate connection provider will be suggested then its really appreciated and helpful.

What I have tried:

I have tried using the connection provider Microsoft.ACE.OLEDB.12.0,its working fine when the Microsoft office access database engine 2007 is installed,but due to licence issue we can't do it in server.
Posted
Updated 7-Jun-18 0:50am

1 solution

Instead of writing to an excel file, write to a CSV or XML file. Both of those can be loaded into Excel.
   
v2
Comments
Member 13204111 7-Jun-18 7:42am
   
What is the connection provider I will be using?I am facing issue with the connection provider.
#realJSOP 7-Jun-18 8:14am
   
You don't need a connection provider to write those kinds of files.
Member 13204111 7-Jun-18 8:51am
   
But I have the requirement to write the 5 different sql query results to a single excel file with 5 different tabs...do this requirement be done in xml file?Can't we use any other connection provider instead of ole db?I have used sql data flow source with excel destination initially,but as the no. of queries are more so that is not suggested,as it will make the SSIS package heavy...plz suggest/advise how to proceed?
#realJSOP 7-Jun-18 9:18am
   
How to proceed - learn how to use google. Try this search phrase: "c# write xml file for multiple excel worksheets".

I guarantee you'll find an answer.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900