Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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 03, 2013 2:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 07, 2014 3:56 AM
Points: 200, Visits: 778
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 03, 2013 1:38 PM



Group: General Forum Members
Last Login: Yesterday @ 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1449350
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse