使用SSIS在SQL中导入多个Excel数据表 [英] Import multiple Excel sheets of data in SQL using SSIS

问题描述

你好，



我有一张Excel表格，它始终是打开的，每隔2分钟就会更新该excel文件中的值。我想在每2分钟后导入SQL表中的所有值，因此我使用的是SSIS。我已经按照以下步骤进行了这项工作。



- 我创建了SSIS包

- 为SQL和Excel添加了连接管理器。 br />
- 在配置两个连接时进行所有必要的更改。



但它给了我以下错误：

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:

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.

有人可以帮我吗???

除了错误，我想使用For循环或For循环容器，每2分钟从Excel导入数据。建议随时欢迎并提前感谢。

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.

推荐答案

安装正确的驱动程序或使用正确的位运行包。

And我不认为SSIS可以读取在另一个应用程序中打开的Excel文件。



我强烈建议你尝试一种完全不同的策略。

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.

这篇关于使用SSIS在SQL中导入多个Excel数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！