Alternate of SSIS script task connecting string provider=microsoft.ace.oledb.12.0

Question

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 6-Jun-18 23:14pm

Member 13204111

Updated 6-Jun-18 23:50pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

#realJSOP · Answer 1 · 2018-06-06T23:52:00

Solution 1

Instead of writing to an excel file, write to a CSV or XML file. Both of those can be loaded into Excel.

Posted 6-Jun-18 23:52pm

#realJSOP

Updated 6-Jun-18 23:54pm

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.