Hi,
I am performing database conversion for a database of a 100 tables,
each done by separate data transformation task. Task are ordered using
precedence constraints.
Is there any convenient way of diving tasks into phases (or groups of
tasks) and choose on each exectution which phases to perform?
(for example, my script failed after table number 50, so next time I do
not want to redo first 50 tables, rather, i want to proceed with tables
51..100. But it's quite inconveniet to go through each task and, for
example, change precedence constraint so that it doesn't run)
Thanks a lot
Irene

If you are using DTS, you have to create your own checkpointing. Use an
ActiveX script to write to a file after each group of tasks. When you run the
package the next time, read the file to find out where you need to start
from, and from your script disable the tasks you don't want to run again. I
am afraid that there is nothing built into DTS to give this type of
functionality. If you upgrade to SSIS, you will find that this functionality
is built in.

Cheers,

Charles Kangai, MCT, MCDBA

"Irene" wrote: