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
Author
Message
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: Friday, October 17, 2014 6:39 AM
Points: 217, Visits: 870
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:14 PM
Points: 7,125, Visits: 12,719
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