You need to include all of these tasks in a Sequence container. This will process each task in a "transaction". If one fails, you can set up SSIS to roll back the process.
Setting it up is little move complex than "just putting them inside the container", but that should get on you the right track.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk