Is there a way to maintain table structure via DTS?

If you are asking will DTS given the Source table changing address that
change on the destination? Then no.
Once the meta data is locked in from design time it is not changeable by the
existing package by itself without you helping it out.

Do you envisage this happening?
Did I correctly guess your requirements?

--
--

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


"Wikus Schalkwyk" <wikus (AT) experient (DOT) co.za> wrote

Well, the one table is maintained by our client. They can add or remove
fields from a table in the database, from which the websites forms are drawn
[almost like a webpage editor]. The fields are saved in the database and
might be required in the dimension as well.

To lessen maintenance for myself, I'd like the DTS package to dynamicly
restructure the "Destination" database according to the "Target" database.
So that when I do go to the client, I don't hav to spend hours of
reconfiguration and testing, instead I can just modify the cubes and
dimensions accordingly. Since they are behind a firewall and hav strict
security policies, I can't connect to there SQL server remotely [which would
be nice].

If however, it is not possible to maintain database structure via DTS, I
shall pack a basket and go looking for way of doing it. As well as, I have
about a months experience in DTS [via the web and help files], so I'm also
don't hav all the answers.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote