Why isn't there a function to ignore all timestamp fields while copied data
from one database to another? I had to set "ignore" for the timestamp for
over 400 tables !!!

The only way I could think to do this currently would be to write your own
task code to look through all the DataPump tasks and interrogate the
SourceColumns property and their DataTypes. If found then you remove the
transform for that column. Not nice but it is doable.

Allan

"Bernhard Pichler" wrote:

I have done it, but as there is no sense in copying a timestamp field the
dts-package should have it as an option to ignore all these fields!

"Allan Mitchell" wrote: