Post reply

Transfer SQL Server Objects Task

  • January 17, 2012 at 8:18 am

    #262833

    Hi,

    i am using this task to copy one DB to another DB..but in the mean while i get this below error...

    [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (89)" and "output column "ErrorCode" (14)".

    helpFile=dtsmsg100.rll helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}".

    help me friends...

    Thanks,
    Charmer

  • January 17, 2012 at 8:25 am

    #1434642

    This task is a nightmare! Sure you cant backup/restore or detach/reattach?

    Check out all the options for this task I'm sure it will be one of them thats causing this; make sure CopyAllSchemas is set to true.

    Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified

  • January 17, 2012 at 9:54 am

    #1434709

    Robert Murphy UK1 (1/17/2012)

    This task is a nightmare! Sure you cant backup/restore or detach/reattach?

    Check out all the options for this task I'm sure it will be one of them thats causing this; make sure CopyAllSchemas is set to true.

    it is true only..but still get error

    Thanks,
    Charmer

  • January 20, 2012 at 12:33 pm

    #1436690

    Look into that, it's not difficult and works better

    http://qa.social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/1aa78469-cbb5-4e22-8448-2a528ba580f3

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply