I used DTs packages to update destination database and I simly execute it by selecting a package > right click >execute package.

Error occur due settings not done for Tranfer Data Task ....issue resolved 🙂 n thanks for repli

Can u guide me how to make backup of DTs packages in sql server 2000,As they are save in sql server and someone said they are in :

(msdb.dbo.sysdtspackages) where i can find it in sql serevr ..

kindly repli