news:1167777897.160161.96810@i12g2000cwa.googlegroups.com...
>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.
>

news:1167777897.160161.96810@i12g2000cwa.googlegroups.com...
>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.
>

> 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)
> -----------------------------------------------------------------------------------------------------------------------
>
> <kki***@gmail.com> wrote in message
> news:1167777897.160161.96810@i12g2000cwa.googlegroups.com...
> >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.
> >

"ep3hatchsi" <kki***@gmail.com> wrote in message
news:1167861046.777280.222770@q40g2000cwq.googlegroups.com...
>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)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> <kki***@gmail.com> wrote in message
>> news:1167777897.160161.96810@i12g2000cwa.googlegroups.com...
>> >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.
>> >
>