A faster way to insert a large number of records on a remote SQL Server

[cory_jackson]

So the ADO BulkCopy will essentially copy the entire source table A in one transaction to a new table B at the destination? IE as a single object. I'm just trying to get a concept.