I am trying to copy the data and tables from My server(SqlServer2000) to another Server(MSDE2000A) using DTS, after some time i am getting an Error " the login PDD Doc handler doesnot exist" failed to copy the data. How to fix this, appreciate your help
Does the mentioned login owns any of the migrated tables in the sources database ? if so you would have to create the login first in the target first. Or better have dbo be the owner of all the tables.