I am not familiar with writing scripts to perform the backup operations for all of my databases. The maintenance plan was created using the GUI in Enterprise Manager. ...

I was able to restore the database from the backup file created.

SQL Server 7.0, SP3

I have found that the DTS actually runs using the NT Account of the user and not the login and password supplied in the LoadFromServer method. I had to...

Thank you, this seems to be working.