SQLBulkCopy and SQL Server 2000?

Hi all,

Does .NET 2.0's SQLBulkCopy class work with SQL Server 2000?

Thanks!

Mar 8 '07 #1

1755

On Thu, 08 Mar 2007 05:04:35 GMT, Spam Catcher <sp**********@rogers.comwrote:

¤ Hi all,
¤
¤ Does .NET 2.0's SQLBulkCopy class work with SQL Server 2000?

Yes it does.
Paul
~~~~
Microsoft MVP (Visual Basic)

Mar 8 '07 #2

William $Bill$ Vaughn

Actually it works with any data source that can be fetched with a
DataReader. You can suck in data from ODBC, OLE DB or other .NET providers
including text files, other databases or a bread box if you have a driver
for it.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Paul Clement" <Us***********************@swspectrum.comwrote in message
news:hg********************************@4ax.com...

On Thu, 08 Mar 2007 05:04:35 GMT, Spam Catcher <sp**********@rogers.com>
wrote:

¤ Hi all,
¤
¤ Does .NET 2.0's SQLBulkCopy class work with SQL Server 2000?

Yes it does.
Paul
~~~~
Microsoft MVP (Visual Basic)

Mar 8 '07 #3

Similar topics

SqlBulkCopy problem

by: GB | last post by:

Hello: I am developing C# project, using ADO .NET 2.0 to connect to SQL Server 2005. I created a DataTable from scratch, and then use SqlBulkCopy to insert it into an empty table in a SQL Server...

C# / C Sharp

SqlBulkCopy and transactions

by: Oscar Thornell | last post by:

Hi, I am trying to enlist an instance of SqlBulkCopy into a transaction. When I executes and try to write to the database I´ll get an exception indicating a transactional deadlock. ...

C# / C Sharp

SqlBulkCopy fails during process exit

by: Cwappy | last post by:

I have a class that builds a DataTable and then, when the process is exiting, tries to write that DataTable to SQL Server 2000 via the SqlBulkCopy class. I know the process is exiting because I'm...

.NET Framework

SqlBulkCopy.WriteToServer SqlException

by: harleedavidson | last post by:

Using SqlBulkCopy.WriteToServer to upload a datatable and getting: System.Data.SqlClient.SqlException Line 1: Incorrect syntax near 'COLLATE'. Database Server is SQL2000, database in in 6.5...

C# / C Sharp

Identity in sqlbulkcopy

by: Shawn Ferguson | last post by:

How do you handle identity fields when using SqlBulkCopy ? textfile - no identity to sql server identity field - only additional field in sql server.

C# / C Sharp

Looking for a SqlBulkCopy that can do UPDATE...

by: TheSteph | last post by:

Using : MS-SQL 2005 / .NET 2.0 / VS2005 I have two server with the same database def but different data. I would like to import data from Server2.TableA to Server1.TableA. If a row doesn't...

C# / C Sharp

SqlBulkCopy.WriteToServer() blowing up on tables with Identitycolumns

by: Dave | last post by:

I'm using the SqlBulkCopy object to bulk insert large DataTable's into SQL Server. Its working well except tables with IDENTITY columns in them. When calling...

Microsoft SQL Server

SQLBulkCopy memory leak..

by: Amar | last post by:

Hi, I need to insert a large amount of records pretty frequently through my application. The quickest way to achive this seems to be SQLBulkcopy class. I have implemented the solution using the...

C# / C Sharp

SQLBulkCopy memory issue question

by: SteveB | last post by:

Hi All, Using the SQLBulkCopy for big CSV files consumes almost all the memory in the computer. I found how to resolve this problem while google that, but no code was added. The person claimed...

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing