I am trying to dynamically define the transformations of a data pump task
with pre-constructed activex script files.
For ex, if file name = xxx.txt then the transformation file = xxx_script.txt
I am doing this because files I loop through all have different structures.
Hence the dynamic transformations.
However, the activex script engine keeps throwing the error - Invalid
procedure call or argument "DTSDestination".
I look at the transformations, everything looks perfect. The right file was
loaded, all columns are mapped properly and the syntax is fine as well.
What is this error and what is happening?