I found that I had to set the IDENTITY_INSERT to ON, before I did the INSERT. Then I turned it back off again, which is the default.

To make it painfully obvious, what I did was this:

SET IDENTITY_INSERT [DESTINATION_TB] ON

then I did the insert as was specified in the article. After doing the insert I did the following:

SET IDENTITY_INSERT [DESTINATION_TB] OFF