• aaron.reese (2/4/2013)


    Thanks Phil, That was a useful lesson.

    Unfortunately I can't see how to assign the value to a variable without using a script. I have tried sending the output to a new flat file but the file gets written even if there is nothing to put into it.

    OK, my flippant comment about setting a variable was not very helpful - sorry.

    But there is a way to do this, using the same technique I mentioned. After the conditional split, put a RowCount component in the 'Success' branch and fire the result into an int variable which has been initialised as zero.

    At the end of the data flow, you have an int variable which is either 0 or 1 and you can use that in your precedence constraints.

    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.