>You need to issue a
>
>SET IDENTITY INSERT database.dbo.tablename ON
>
>on the table to be updated then
>
>SET IDENTITY INSERT database.dbo.tablename OFF
>
>as only one table can have set identity insert on per transaction.

Yes, the code I have now takes care of all that.