Ah,,,,,, ok.  So the script c# component should issue a begin tran, but I'm not connecting the script component to SQL, it opens the Excel file and process rows through...

Thanks Steve, but sadly no explicit transaction declared, it's as though the foreach loop is opening a trans, then when the Dataflow errors, it rolls the lot back.  It's a...