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

What to watch out for

If we disable Use fast load on the options tab of the DataPump task and we try to send data to the identity column then we can receive an error like this.

Fig 4

ErrorNoFast

Now let's say that we create an ActiveX transformation between the source and destination tables. We do this by removing the current transformations. We then do

Select All --> New --> ActiveX Script

We then get into a screen which has tabs to show us our source and destination columns that we have selected

Fig 5

SourceAndDest

Pressing the properties button will take us to the screen where we can define our script.

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