How To Pass In The Current Database, Server Name To A Sendmail Task

Hi all--I am writing a DTS package looking to back up all databases in sequence from a specific instance of SQL Server. I am calling CDOSYS in a stored procedure from support.microsoft.com to send email upon failure. I have two types of SQL tasks I am writing into the DTS package:

1. backup database <database> to disk = '<drive>:<path>.bak' with init

2. Upon failure of a particular database to back up to file, execute the following SQL task:

declare @srvname varchar(128),
@db_name varchar(128),
@msg nvarchar(4000)

SELECT @srvname = @@servername
select @db_name = db_name()
set @msg = 'Hi--check your database backups. The ' + @db_name + ' database backup on ' + @srvname + ' has failed.
Thanks--SQL Server';

SELECT @srvname, @db_name, @msg

(Many thanks to Whitney Weaver and SQL_Menace for help with sections of this code)

Upon success of #1 and/or #2, go on to the next database, repeating cycle of the SQL tasks above for the next database in the task. For example, this logic goes like:

1. Back up master database; if fails, send email in SQL task; if either task is successful, goto database #2;

2. Back up model database; ...<etc>.

My problem is the current database set in @db_name. I apparently need to reset this variable for each database that gets backed up, and I can't seem to get these set as values to be passed from SQL Task #1 to SQL Task #2. Any suggestions on how I might achieve this?

- Jonathan