>I thought about using a remote view but I wanted to explore some other options. My main concern is speed of the update and network traffic. The first choice would be to schedule a DTS package job to run in the middle of the night. I would like to have the user be able to run this job either directly or by a stored procedure (if possible?) Would it be better to use a remote view with a possible record set of several thousands?

I guess it would depend on how competent your "user" is since you mentioned you wanted this to happen with a button click. I was assuming this needed to be super simple for the user. It also depends on what you already have written. If not much, I would go with the RV. Otherwise, you can write code that will create the SQL statements to insert the records and use SPT on each record. This is basically what the RV would do, but you would be skipping the APPEND FROM step.

I am not familiar enough with SQL Server to advise you any other way. However, I would think their is a way to bulk load records in much the same way you can do so in Oracle. However, that takes a reasonably knowledgeable user and is definitely not going to happen with a single button push, at least not with Oracle.