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.)

The picture below is what you will see when looking at the last tab of the DataPump task. As you can see it is here that you can set the DTS equivalent for the IDENTITY_INSERT property, Enable identity insert. By default it is off (unchecked) so go ahead and check it as we want to insert the source values.

Fig 2

CheckIdentity

Now execute the DataPump task. If we select from the table we get the following.

IdentityColumn MyCharacterCol
------------ ----------------
1              A

(1 row(s) affected)
Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7