Moving from DTS to SSIS

Dec 24, 2007 at 11:43 AM
Using DTS I would run a script to trancate a table before loading we data. Using the on success I would then progress to load the data. How do you do this in SSIS. How can you run the sql statement and how do you set complete, success or fail options.