Answered by:
Foreach Loop container of SSIS Package hidden error!

Question
-
Hi
I've created SSIS package to import data from multiple excel files in a folder. The package is working fine but it reads the first excel file and repeat this operation according number of excel files in the folder, for example : if there 10 excel files the package will read the first excel file 10 times.
what is wrong with that?
SSIS package "C:\Users\Administrator\source\repos\SSIS-ETL\Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Warning: 0x80049304 at Data Flow Task, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [39]: The final commit for the data insertion in "OLE DB Destination" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 72 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. SSIS package "C:\Users\Administrator\source\repos\SSIS-ETL\Package.dtsx" finished: Success. The program '[8968] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).
BR
Abdullah
- Moved by Dave PatrickMVP Sunday, December 27, 2020 8:46 PM looking for forum
Sunday, December 27, 2020 8:15 PM
Answers
-
I'd try asking for help over here.
sql-server-integration-services - Microsoft Q&A
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.- Proposed as answer by Dave PatrickMVP Wednesday, December 30, 2020 10:07 PM
- Marked as answer by Guido Franzke Monday, January 4, 2021 8:22 AM
Sunday, December 27, 2020 8:46 PM