Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
Problems With IDENTITY() and the DataPump task.
By Allan Mitchell
Version 7.0
Level Beginner
Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7

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

ErrorInsert

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.

Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7