Import multiple Excel sheets of data in SQL using SSIS

Question

0.00/5 (No votes)

See more:

Hello,

I am having an Excel Sheet called which is always open and the values in that excel file are be updated after every 2 minutes. I want to import all the values in SQL table after every 2 min therefore I am using SSIS. I have followed below steps to make this work.

- I have created SSIS Package
- Added Connection Manager for SQL and Excel.
- Make all the necessary changes in configuring both connection.

But it gave me below error:

CSS

Error: 0xC0209303 at Package1: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".
Error: 0xC001002B at Package1: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. For more information, see http://go.microsoft.com/fwlink/?LinkId=219816
Error: 0xC020801C at Data Flow Task, Excel Source [2]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: Excel Source failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "D:\Shraddha\test\test\test\Package1.dtsx" finished: Failure.

Can someone help me on this???
Apart from the error, I would like to use For loop or For Loop container, to import the data from Excel after every 2 min. Suggestions are always welcome and thanks in advance.

Posted 16-Apr-15 15:03pm

Member 11410952

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)

PIEBALDconsult · Answer 1 · 2015-04-16T15:12:00

Solution 1

Install the correct driver or run the package with the correct bit-ness.
And I wouldn't think that SSIS could read an Excel file that is open in another application.

I strongly suggest you try a whole different tactic.

Posted 16-Apr-15 15:12pm

PIEBALDconsult

Comments

Member 11410952 16-Apr-15 21:29pm

Hey,

Thanks for your quick response.
Could you please suggest what I should do if I have the requirement as mentioned above??? Can you suggest me some other option in which it can work as expected.

PIEBALDconsult 16-Apr-15 23:45pm

You would need to be clearer on _what_ you are actually trying to accomplish, not _how_ you are trying to do it.