对于每个循环容器（使用多个工作表加载多个excel文件） [英] For each loop container(Load Multiple excel Files with multiple sheets)

问题描述

大家好，

我有新的要求，我需要在SSIS包中加载多个excel文件，在每个excel文件中它将有4张。

对于包的下一次执行，excel文件将添加另外一张，所以现在我将有5张。当我尝试执行该程序包时，我将收到一条错误，其中添加了额外的工作表未正确映射到目标。

如何处理此过程。请尽快回复我。

解决方案

您需要一个嵌套循环（1表示excel文件.1表示表）

两个变量，文件名和表格名称

https://www.mssqltips.com/sqlservertip/4157/how-to-read -data-从-多Excel的工作表-与-SQL服务器集成服务/

Hi all,

I am having new requirement that I need to load multiple excel file in SSIS Package and in each excel file it will have 4 sheets.

For the next run of execution of package the excel file will be added with additional one sheet so now I will have 5 sheets. When i tried to execute the package I will get an error that added additional sheet doesn't mapped properly with destination.

How to handle this process. Kindly reply me as soon as possible.

解决方案

You would need to have a nested loop (1 for excel file. and 1 for the sheet)

Two variables, filename and sheet name

https://www.mssqltips.com/sqlservertip/4157/how-to-read-data-from-multiple-excel-worksheets-with-sql-server-integration-services/

这篇关于对于每个循环容器（使用多个工作表加载多个excel文件）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！