Is the archive on the same server? If so, Steve has the right approach. If not it gets more complex.

One note: if the schema changes you have to remember to change the process and the schema in the archive, this often gets forgotten, right up until the moment that the process starts failing..

CEWII