Re: Copy a database table into another using ado.net
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxxx>
- Date: Wed, 3 Jan 2007 10:42:43 -0800
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.
.
- Follow-Ups:
- Re: Copy a database table into another using ado.net
- From: ep3hatchsi
- Re: Copy a database table into another using ado.net
- References:
- Copy a database table into another using ado.net
- From: kkizer
- Copy a database table into another using ado.net
- Prev by Date: Re: Storing Connection String
- Next by Date: Re: VB.net and ASP.Net Typed Datasets
- Previous by thread: Re: Copy a database table into another using ado.net
- Next by thread: Re: Copy a database table into another using ado.net
- Index(es):
Relevant Pages
|
