Hey guys, I'm hoping you can help!? Im new to all of this so bear with me!

I have a DTS that copys a database table from one sql database to another. The databases are stored on 2 different servers. I have set the DTS so that if the copy fails for any reason that it send me an email explaining this. I need in that email to display the step/s that failed.

Is this easy?!