I don't like the ftp task in DTS either.  It doesn't sound like you really even need DTS though.  Just take your delete table statements and put them in one...

That's odd.  It's always worked for me.  I'm assuming you're not getting the same exact error message now.  Can you post the new error message?

Ok let me know one thing, if i try to restore backup to a different machine which has no logins/users defined as there were in the machine i initially had...

You don't need to get fancy with the update.  You are on the right track though.

UPDATE sysjobs

SET originating_server = 'SD0-SQL'