Click here to Skip to main content
15,916,692 members
Please Sign up or sign in to vote.
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

1 solution

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.
 
Share this answer
 
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.

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