Hi,

I have a situation when have to move data between two tables b/n two
different databases. Have written an activex script to handle the
transformations dynamically as the tables might differ with every
execution e.g. table A to table A the first time or table B to table B
the second time and so on.

My activex script drops all the existing transformations and
generates/adds new transformations based on the columns in the table
specified but when I execute the data transform task it gives an error
"The datapump requires transformations to be specified". Now I go to
the transformations tab and to see the transformations are defined but
none selected.

My question is how to I preset the transformations which I created
dynamically?

Please let me know.

Thanks,
Jay.