sql server dts: Hi,

Here, the scenario is:
dimension members can be added/deleted on the fly. So depending on if
any of the members are deleted from dimension table, I want to rebuild
the dimension through DTS package. Is there any solution to this
problem?

Regards,
Gayatri.

Sorry for not explaining the context.
Actually, I have OLAP cube which has the following dimensions:
1. Metrics
2. Server (Physical machine)

So there are certain metrics associated with each server. And these
metrics can be added on the fly, which would need the dimension to be
rebuild. So is there any way to do this?

Regards,
Gayatri.