Post reply

SSIS For Each Loop - Multiple wildcards

  • May 3, 2013 at 2:30 am

    #292920

    Good morning/afternoon/evening...

    I've ran into an issue with a for each task that loops around a folder processing zip files, everything works fine with a *images*.zip wildcard but I am wanting to break it down further and have multiple searches such as 01*images*.zip; 02*images*.zip - sadly it results in a non-starter.

    I know I can probably check in code or something similar, just wondered if there was a way to have different patterns in the filename or is it impossible?

    Thank you!

    'Only he who wanders finds new paths'

  • May 3, 2013 at 1:38 pm

    #1612333

    No, but you can search for *.zip and then use Precedence Constraints within your Loop container to run different paths of code based on the actual file name.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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