Re: Copy a database table into another using ado.net

Tech-Archive recommends: Fix windows errors by optimizing your registry

I am using visual studios 2003. does that not use ado.net 1.0?




William (Bill) Vaughn wrote:
No problem. ADO.NET 2.0 exposes the SqlBulkCopy method that does what DTS
does...
hth

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

<kkizer@xxxxxxxxx> wrote in message
news:1167777897.160161.96810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I need help! Here is what i have going. I have a cobal database that i
connect with using a DSN/ODBC (the source data) and i have a Sql 2000
database that i am trying to copy the data to. I have a DTS package
setup doing this task just fine but i need to do this process using
ado.net/vb.net, not using DTS (dont ask why, long story). I have been
searching around places and just cant find any good code examples to
help me get started. Can anyone helP?

I already have the tables setup in sql server and they are identical to
the Cobal database.


.

Relevant Pages