<div>
Do you move the file that has been processed to another folder?<br />
<br />
Also, do confirm that the iterator is configured correctly and that the value fetched from the iterator is used in the tasks inside the ForEach Loop (e.g. maybe the loop may be iterating over 10 files correctly, but all the 10 times, the tasks inside the ForEach loop are referencing the same file due to some hard-coding)
</div>


<div>
I do, but thinking of how to get the the ForEach loop to start with one file first, then begin with the second file
</div>


Sample files on processing files in a folder via For Each loop

002A_FileRenameForMove.xml

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I have a SSIS Foreach loop,and within it a Sequence Container that keeps looping over the same specified file more than once, thereby creating duplicates in the destination table.<br />
<br />
Is there a way i can have to loop files within a folder just once, one-by-one?
</div>
</div>


Hello

I have a SSIS Foreach loop,and within it a Sequence Container that keeps looping over the same specified file more than once, thereby creating duplicates in the destination table.

Is there a way i can have to loop files within a folder just once, one-by-one?

SSIS Foreach Loop repeating itself more than once on a file.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.