Thank you all for responding to my question. File based export (DTS, BCP, or SQL BULK INSERT) works great when the client and the destination database server are on the same machine. Configuring a shared drive is not an option for us.
Bob Beauchemin's suggestion of using IRowsetFastLoad looks like the best option. I guess I can live with some interop till .NET 1.2 is released. Thank you once again for your help. Pradeep =================================== This list is hosted by DevelopMentor� http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com
