> 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

Allan Mitchell wrote:
> 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
>
> > 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