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.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.