You see, I have long suspected that the ForEach File Enumerator type in SSIS's ForEach Loop Container does not process time stamped text files ...
I have a SSIS package that uses a Foreach Loop Container to iterate through a series of flat files. The order in which the files are iterated ...
Has a single task in the ForEach loop and a breakpoint set at pre-execute; 3. A variable to hold the file name. Pretty simple, the ssis package looked like: Pretty ...
I'd like to ensure that my SSIS (2012) Foreach File Enumerator processes the files in order of creation date. Ideas? Jim. Igor Micev. SSC- ...
I want my files to be process in filedate order, but the foreach loop
In a previous post, I answered a question regarding SSIS packages
Use this variable in Foreach Loop Transformation to read through the files in the desired order. I have created a blog post on this including the ...
In this post, I explore how the For Each Loop Iterator can be made to iterate through files in a specific sequence from a given folder.
Loading Multiple Files / Implementing FOREACH Loop in SSIS. In order to load multiple source files which can done at control flow tab so to implement that we ...
It would be nice if the SSIS For Each Loop Enumerator could provide the