使用SSIS包将多个Excel文件导入SQL Server 2008 R2吗?

问题描述：

我必须使用SSIS打包将数据从两个不同的excel工作表插入两个表中.

I have to insert data into two tables from two different excel sheets using SSIS packges.

所以，请告诉我如何使用SSIS包将多个Excel文件导入SQL Server 2008 R2?

So, please some one tell me How to import multiple Excel files into SQL Server 2008 R2 using SSIS Packages?

答

因为您只有2个excel文件和只有两个表，所以我看不到为什么要使用foreach循环.只需遵循此链接并直接执行

since you have only 2 excel files and only two tables I don't see why use a foreach loop. Just follow this link and do it directly

如果您需要将两个excel文件都插入两个数据库中，则可以使用多播组件来创建数据集的副本

If you need to insert from both excel files to both databases you can use a multicast component to create a copy of a dataset