> Hi all,
>
> I have this problem where I have to frequently change the target
> database of my transform data tasks. I've already figured out how to
> change the destination tablename through ActiveX script, but I don't
> know how I can drop all existing transformations and recreate them
> (since they remember old values and don't work) in the same script.
> Each of the transformations merely maps a source column to a
> destination column. Here are my questions:
>
> 1) I've read somewhere that I actually don't need to recreate the
> transformations. All I need to do is to dynamically change the source
> table as well. Is this correct?
>
> 2) If I do have to recreate the transformations one by one, how can I
> create them? Do I have to specify all of the properties? Or do I
> just do something like DTSDestination("Role") = DTSSource("Role")?
>
> 3) What I have currently is I first copy all existing transformations
> to an array, delete all existing transformations, then all each of the
> transformations in the array back. However, this doesn't work. Does
> it have to get this complicated?
>
> All thoughts and comments are helpful!
>
> Thanks for your time in advance.
>
> Regards,
>
> Jada
>