Post reply

Lookup no-match output runs even when there is no no-match output

  • September 24, 2013 at 2:40 pm

    #282881

    I have a lookup transformation that redirects rows with no matches to a no-match output. The no-match output then flows to a flat file destination that creates a csv file containing the no-match data. The problem I'm having is that the csv file is getting created even if there is no no-match output! It simply creates a blank csv file. How do I tell SSIS to create that csv file ONLY IF there is no-match data?

    Thanks.

  • September 24, 2013 at 2:46 pm

    #1652888

    I believe it will still create it anyway.

    If the empty file is such a problem, you can always delete it right after the data flow. Add a row count component between the lookup and the flat file destination.

    This stores the result into a variable. After the data flow, add a precedence constraint with the expression @RowCount > 0 to a file system task which will delete the file.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 24, 2013 at 2:49 pm

    #1652891

    OK, that should work. Thanks! Kind of stupid for it to perform an unnecessary task, but c'est la vie, I suppose. Thanks, again.

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

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