I have a number of DTS packages that use rather complex ActiveX
DataPump tasks. The original destination tables have now been divided
into multiple tables unioned by a partitioned view. I am trying to
re-configure the DataPump task in the Designer to use the partitioned
view as the destination, but the Destination tab only displays the
available tables, while the Source tab allows the selection of views.
BTW, data is being migrated from DOS DBFs to SQL tables.

If I can't use a view as a destination I will be forced to write to 30
separate tables differing only by a column constraint or use a staging
table as the destination and then run a separate SQL task to move the
data from the staging table to the partitioned view. As there are 2.5
million records, this extra step can add a considerable amount of time.
I must get the transforms completed in a reasonable amount of time to
get the producion staff back up and running by the next morning.

There are 12 tables that have been re-designed in this manner, so we
are talking potentially a lot of time.

Any input would be appreciated... TIA