Ok ,here is a slow pitch for you all stars to wail on. DTS script
that will truncate and load 7 tables. Each table load should be its
own transaction.
My solution was to:

1. Disable all workflow transaction properties
2. Create a SQL Begin Trans script
3. Create a SQL commit trans script and after successfull load
execute the commit
4. on a script failure run a rollback transaction script


This seems to be working ok. Is this a fair solution or poor
practice. This is contained in one dts script....