• Two options:

    1) Remove the IDENTITY definition on the destination table and insert as usual.

    2) Set identity insert on during the import and insert as usual.