Home Forums Data Warehousing Integration Services For Each File Logic RE: For Each File Logic

  • March 7, 2014 at 6:37 am

    #1695091

    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.

    Lowell

    --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!