Hi, I am using a DTS designer to convert a database. In the transform
data task, I am using "active-X transformations". Now, If I make
changes in the destination database structure (table structure), I
cannot access the script anymore, because the only options are:
- "change sourse and destination"
- "remove invalid transformations".
If there any way to deal with this without loosing the scripts written?
Thanks

Hello Irene,


No not really. Well there is but it is convoluted.

What I would do is go into Disconnected |Edit and go and grab your transform
script.

The problem is that the SourceColumns AND/OR the DestinationColumns for the
transform have changed and this renders the transform invalid. DTS does
not know how to remap thinigs to the way they are now.


Allan

Thanks a lot Alan, that was very helpful
Irene

Allan Mitchell wrote: