Re: Automapping new table column in DTS transformation task...

#1

In article <066A292E-55BC-441F-8A9B-7D2CF7C31656 (AT) microsoft (DOT) com>, Ronnie wrote:

Quote:

Here is my problem: We have about 200 different DTS packages running on 48
different production servers. Anytime we add or delete a columns from a
table, we have to go and modify the transformations for these tables. This
is a definite pain, because all we really do is open the transformation,
delete the mappings, click the destination tab, then click the transformation
tab. The SQL DTS editor automatically maps what we need. Then we save it.
Is there a way to have it do this “simple” task automatically without me
having to delete the transformation and have SQL remap it? I mean SQL has
enough sense to remap it automatically, so why can’t it do it by itself? Any
info anyone has would be greatly appreciated.

Thanks,
Ronnie...

The short answer is No.

When you delete the mappings and then rerun the mappings the DTS package rechecks
the metadata.

You can of course do this progrmmatically. You can in the case of an "Add",
create new transformation and map the columns accordingly. For the "Remove" you
will need to find the transformation that contains the column and remove it from
the collection.

Not pretty but that is your option.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Automapping new table column in DTS transformation task...

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Automapping new table column in DTS transformation task... - 09-18-2004 , 05:40 AM