This took approximately 1 hour to load 168,261 rows.When I used a linked server and a Select into statement it took 10 seconds.
This should not be the case. This difference is quiet huge. Are you sure both activity is doing the same thing.
----------
Ashish