>I'm not using buffering on the view, it is pointing to a temporary table on SQL Server - when finished, I fire a remote stored procedure to do the update internally on SQL (including dropping and rebuilding indexes).
>

So you are appending to a view of a temporary table, then with a SP from the temp table to the production table?

I'm curious, What is your reason not useing a view of the production table and skipping the second step?

>I only asked for an SPT way because I feel like I'm 'stepping back' using the view - I would rather do it with SPT if this was possible. Just exploring all the avenues!

View and SPT are really the same thing.

BOb