Post reply

Wildcard character to ignore a letter in SSIS for each loop container

  • January 19, 2012 at 10:25 am

    #391356

    Hi All,

    I have set of files to read from in follwing 2 formats:

    doc60.txt , doc601.txt, ----till doc609.txt

    and

    doc60n.txt,doc60n1.txt,doc60n2.txt-----till doc60n9,txt

    I have created 2 simple packages using FOR EACH loop container to read one by one using doc*.txt and doc??n*.txt

    The problen is coming with the first package as it tries to read all doc*.txt as well as doc??n*.txt..

    So I want to ignore n character in this read....Any help how to achieve this in SSIS.

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • January 20, 2012 at 9:09 am

    #1436583

    Probably your best bet is to put a dummy script component in your foreach loop, and then connect that script component to your real component. In the connector linking the dummy script component to your real one, change the condition to be an expression, and make the expression evaluate the file name. Cause it to continue only if it satisfies your criteria.

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

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