New to DTS and not a DBA, but would like to know if source contains
more fields than a target is it possible to add those fields to the
target in DTS .... actually I will be using the DTS APIs. Thanks.

You could enumerate the information_schema views on the source and the
destination, compare the two and then construct the relevant ALTER TABLE
ADD.... statements. Your next Q will more than likely be can I then
dynamically map these columns in a DTS DataPump Task.

Yes you can. You would add the columns to the SourceColumns and
DestinationColumns properties of the Transformation object. It is doable.


"elizabeth" <ezelasky (AT) hotmail (DOT) com> wrote