SQLBulkCopy and SQL Server 2000?

8 Mar 2007 5:04 AM

Spam Catcher

Hi all,

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

Thanks!

8 Mar 2007 3:04 PM

Paul Clement

On Thu, 08 Mar 2007 05:04:35 GMT, Spam Catcher <spamhoneypot@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)

8 Mar 2007 4:53 PM

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)
-----------------------------------------------------------------------------------------------------------------------

Show quote

"Paul Clement" <UseAdddressAtEndofMess***@swspectrum.com> wrote in message
news:hg90v2h7utqvciq7bvisimotbofs2enoht@4ax.com...
> On Thu, 08 Mar 2007 05:04:35 GMT, Spam Catcher <spamhoneypot@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)