Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    18

    Question Unanswered: Sql Server "failed to copy the data"

    Hi,
    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
    Thank You

  2. #2
    Join Date
    Aug 2004
    Posts
    5

    Smile who is the Owner of the tables

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •