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!