Trigger DB backup from DTS package?

[Seabz420]

SQL Server 2000

Is it possible to trigger a backup from a DTS package? I need to perform a backup once a month but the dates vary so scheduling won't work. Also, it needs to be dummy proof so for someone to just trigger the DTS which could trigger the backup would be ideal. Thoughts? Thanks
Evan

 

[Seabz420]

I should have been more specific. The backup is of one database. Each month we receive, from our parent company, data that we upload to SQL and we take the old data and archive it. We've now worked it so SQL will directly connect to the parent DB and import the data (using DTS packages). Now we want a DTS package to trigger the backup to make an archive of the old database. Make sense?!

 

[Seabz420]

Here's what I managed to get from the SQL help..

USE master
EXEC sp_addumpdevice 'disk', 'XX_Backup', 'D:\XX_Backup.bak'

BACKUP DATABASE XX TO XX_Backup

I created a DTS package with an Execute SQL command with this in it and it works.