Post reply

How do not to process file name ending with _0.txt in SSIS

  • June 10, 2011 at 11:34 am

    #252659

    Hi,

    I’m loading flat file data to table. But I don’t want to process the flat file name end with _0 (File name as ABCDE064545534_0.txt).

    Is any way to not process the such type of files. This _0 denote no data in the file, so I don’t want to process.

    Please let know if any way to handle in SSIS.

    Thanks.

  • June 10, 2011 at 3:54 pm

    #1337304

    You're inside a ForEach Loop correct?

    You can set a condition on one of your constraints based on the expression below to prevent further execution where @file_name is the variable mapped from your loop.

    RIGHT(@file_name,6) != "_0.txt"

    If you do not have any components in your ForEach loop container before the first component you want to bypass executing you can add an empty Sequence container, connect that to your first component and set the constraint on that connection.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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