Thanks for looking Koen!
what i mean, is, say you have a folder of files, some file names contain "_Product_" in their names, others contain "_Patient_" or "_Sections_" in their names.
there's at least half a dozen matching files for each substring that i would be processing/looking for.
so my "conditional logic" i was asking about, is can i use a single loop to direct files that meet pattern "*_Product_'.txt" to go to a specific Data Flow, and another pattern to a different data flow?
effectively an if/case/switch: if Instring(filename,pattern) > 0 then ...
or do i just make a dozen seperate loops and walk away?
my prelim SSIS package I'm starting out with is just using lots of seperate loops, and it just bothered me.
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!