Cross DB Table-Mover IDENTITY_INSERT error

Sallesg

Hi,

I have setup 3 Table-Mover rules, on which two of them work perfectly but the last raises the error "IDENTITY_INSERT is set to off". Tables have similar structures. 
I've tried several things but it all ends with the same error.



Some information:
- the table is being truncated before;
- setting table with "identity_insert ON" didn't made difference;
- there's no FK related to the table;

Thanks in advance

Eddie D

Hi,
Thank you for your forum post.

A support ticket has been generated for you, as I need to collect log files and if possible a copy of the MaskingSet you have generated, that you will not want to upload in this public forum.  The support ticket number is #307134.

I will correspond with you via the support ticket.

Many Thanks
Eddie