Post reply

For Each Loop Container in SSIS 2008

  • June 22, 2011 at 4:49 am

    #238325

    I have package that contains For each loop container and it process all the files from a particular folder. The problem I am facing here is before package starts whatever files are in folder get processed once the package start but if some new files come during the package execution those files doesn't get processed.

    For Example: if i have 100 files in folder "Test" and i run the package it process all the 100 files. but if i keep 10 more files during the execution of for each loop container, Foreach loop does not process those 10 files.

    Please let me know if any one has idea about how to deal with such problems.

    Regards,

    Ravi

  • June 22, 2011 at 9:55 am

    #1342538

    The FEL container is operating correctly. I think there is a solution, it is predicated on the files being moved or renamed so they don't satisfy the FEL search criteria anymore.

    Put the FEL in a For Loop.

    Your script withing the For Loop would look at the directory and see if there are any more qualifying files, if so, it would set the variable to 1 which would make it run it again, when it didn't find any it could set it to any other value and the For Loop would exit.

    Clear (as mud)?

    CEWII

  • June 22, 2011 at 10:32 pm

    #1342785

    Thanks, i will try this option.

    Regards,

    Ravi

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply