Re: Uploading Data From MS Acess 2000 ti SQL server 2000

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

Try posting this in the microsoft.public.sqlserver.dts newsgroup.
Someone there may be able to help with the DTS side of things. You
should be able to execute a DTS package from .NET.

--Mary

On Mon, 9 Jan 2006 02:48:02 -0800, gaurav
<gaurav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>hi
>I want to Bulk upload Data from Acess database 2000 to an online Sql Server
>2000.I am using vb.net 2002 as front end
>Can u please guide me
>
>I have come to know about DTS Programming but it dosent work in vb.net it
>gives somekind of incompatible error while creating custom task...
>Second option is Link server.. i m not sure about its use
>the third option is XLM Bulk Upload..I got the got but i dont know how to
>get the SQLXMLBULKLOADLib in my project i dont c any microsoft SQLXml .... in
>the list...
>
>Can u please sen me some sample code of these three topics or if u know any
>better idea please do forward that
.

Relevant Pages

  • Re: dts alternative?
    ... people that send them to us rename columns, dont have the data the way they ... etc. Thats why I need a GUI that isn't DTS. ... There's no way to install just DTS without installing ...
    (microsoft.public.sqlserver.dts)
  • Re: dts alternative?
    ... people that send them to us rename columns, dont have the data the way they ... etc. Thats why I need a GUI that isn't DTS. ... There's no way to install just DTS without installing ...
    (microsoft.public.sqlserver.server)
  • Re: Deadwood DTS Where???
    ... Every retailer I looked at never mentioned any DTS track so I dont know ... If it was in the description in an eBay auction, well, thats your ... > Ok guys same question the region1 boxset says DTS 5.1 for the language but ...
    (alt.video.dvd)
  • Re: What is better?
    ... I dont know if you are asking me about using DTS or using ... DTS without sp? ... >> stored procedure. ...
    (microsoft.public.sqlserver.server)