Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSIS For Each Loop - Multiple wildcards Expand / Collapse
Posted Friday, May 3, 2013 2:30 AM

SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 7:33 AM
Points: 251, Visits: 1,144
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'
Post #1449074
Posted Friday, May 3, 2013 1:38 PM



Group: General Forum Members
Last Login: Friday, December 2, 2016 3:25 AM
Points: 7,933, Visits: 14,355
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
Post #1449350
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse