SSIS ForEach Loop not finding file

  • I used to know how to do this, I think, but I wonder if my memory is playing tricks on me. I need a ForEach loop to find a file that the name changes daily. Normally, I'd use a wildcard (*), but in this case it doesn't seem to be working.

    I've searched all my old code and apparently I usually have a file name prefix before the *, such as MyFile_*, in the Files part of the enumerator config. This time around, I need to find a word in the middle of the file name. Meaning it could start with anything, have the word, then have a date at the end. Examples: MyFile_WORD_20201101 or HisFile_WORD_20210112 or Santa_WORD_someotherdate.

    Which means I need to search on *WORD* but the ForEach Loop doesn't seem to be finding anything when I have the *WORD* in the files.

    And I can't find any reference in Google to using a double wildcard like this. Anyone have any thoughts? Or will I actually need to use a different method for finding these files because *WORD* won't work in the ForEach loop?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • OH GOOD GRIEF!

    My problem was caused by a typo in the NAS share destination (a File System task further down in the ForEach Loop) not in the actual ForEach Loop.

    Nevermind me. *WORD* works just fine.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply