• This error is telling you that you've configured the object transfer to contend with Identity values, but your target table does not actually have an IDENTITY column in it. You have the transfer set to enable identity insert, this needs shut off.

    Are you using SSIS with a transfer objects task? You could likely do this just as easy with the import/export wizard and save your package.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden