SSIS should pick up csv flat files using keyword match

  • Hey guys, here's an interesting scenario I encountered which I believe will be useful for all of us.

    Problem Statement:

    The flat file souce should pick the file with keywords matching the filename. For example If there is a file File01_09042014 in the source location, the SSIS should look for keywords File01 in the source location and should pick up the File01_09040214 file. How do I design this.

    Thank you.

  • Have a look at the FOREACH LOOP container. You can configure it to use wildcard searches of directories and use the result to iterate through it file that matches your wildcard specification. To get it to work, you need to use an expression on the connection manager for you file connection using the variable that you used in the FOREACH LOOP

  • DataEnthusiast (9/9/2014)


    Hey guys, here's an interesting scenario I encountered which I believe will be useful for all of us.

    Problem Statement:

    The flat file souce should pick the file with keywords matching the filename. For example If there is a file File01_09042014 in the source location, the SSIS should look for keywords File01 in the source location and should pick up the File01_09040214 file. How do I design this.

    Thank you.

    I don't understand this part:

    ... pick the file with keywords matching the filename

    Where do these keywords come from?

    Are you just looking for files that start with one of these keywords, once the keywords have been established? How are they established?

    Or are you just looking to process any file that exists in a certain folder?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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