Okay I think I see now.

I've had a bit of trouble with the temp table aspect - I created a temp table in an OLE DB Source query...

I've set the variable using an ExecuteSQl with a rowcount and then used a script to set a success or fail based on the rowcount. Sadly the Fail then...

Am I missing something ? As far as I can see the conditional split only allows you to perform splits according to column content. The only thing I can...