Pradeep, We pump millions of records from text files into a database using stored procedures with parameters. We really wanted to use a bulk copy setup, but we ended up going with a serial approach so we could log and manage exceptions on the .NET side of code.
We do have the text files, log/exception files, database, and .NET code running on the same machine. We did look at building some XML dataset and submitting them to SQL 2000, but the solution we rolled out worked pretty well. John Lomnicki Lead Architect Loyalty Technologies http://www.loyaltytech.com -----Original Message----- From: Moderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Pradeep Tapadiya Sent: Thursday, February 26, 2004 1:08 PM To: [EMAIL PROTECTED] Subject: [ADVANCED-DOTNET] SQL Server bulk copy operation... NETters, I need to pump huge number of records into a SQL Server database. The default SQL Server ADO .NET connector doesn't seem to support any bulk copy operations. I am wondering if I simply overlooked something or if there is a newer SQL Server ADO .NET connector that can be downloaded. I see that the new ADO .NET connector under Longhorn supports bulk data operations. Is this connector available for download somewhere? http://longhorn.msdn.microsoft.com/lhsdk/ndp/adconusingadonettobulkcopydatat osqlserver.aspx Thank you in advance 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 =================================== 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
