Insert data from the source into the destination identity column (contd.)

Let's try a slight variation on our current scenario. In the transformations screen remove the transformation mapping to the identity column, but leave the Enable identity insert option selected. Now run the DataPump task.

Fig 3

If we have set Enable identity insert, the equivalent to the T-SQL SET IDENTITY_INSERT table ON, then we must provide a value for the IDENTITY column.