Re: ADO.NET questions

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: dramos (dramos_at_discussions.microsoft.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 07:35:03 -0700

We are trying to design this app to be compatible with SQL Express 2005.
According to information I have on SQL Express, DTS will not be included in
it so I dont think we can use DTS.

Am I missing something though. My understanding was that using XML files to
move data around was the preferred way in dotNET. Am I taking the wrong
approach in using the dataset writexml method to create a xml file that could
be emailed to another user where he could import back into his version of the
app?

"William (Bill) Vaughn" wrote:

> DTS can export to a flat file that can be reimported elsewhere.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> 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.
> __________________________________
>
> "dramos" <dramos@discussions.microsoft.com> wrote in message
> news:83BB49BA-390C-4021-BE05-3E367FF9834A@microsoft.com...
> >I am novice with C## and ADO.NET. All my prior experience is with VB and
> >old
> > style ADO.
> >
> > We have a desktop application that uses MSDE as its database. We need to
> > have a way to export rows from a few tables from one users computer to
> > another users computer. This has to happen in a disconnected way so using
> > DTS is not an option. These are steps hat I was planning to use.
> >
> > 1)use SQLAdapter to create a Dataset with data to be exported on the
> > source
> > computer.
> > 2)Use DataSet WriteXML method to write out data to xml file.(User then can
> > email xml file to another user)
> > 3)Create Dataset on Target computer and use ReadXMl method to read data
> > into
> > dataset.
> > 4)Modify keys on data so as to avoid primary key violatons
> > 5)Create SQLDataAdapter on target computer. Pass in Dataset with data to
> > be
> > merged while called Update method on SQLAdapter.
> >
> > I have succesfully done steps 1-3 but I am having problems with 4 and 5.
> > Has anyone done anything similar to this? Is this the correct way to do
> > this? Any
> > pointers to examples of how to this is appreciated.
> >
> > Thanks in advance.
>
>
>

Relevant Pages

  • Re: Design Question
    ... The nature of this app is to return results from the routinesand pump out a log file with the results from the .net App. ... Should I poll/trigger when the DTS is complete from SQLServer or from my Vb.net App? ... (I have no preference at the moment - although the fact I'm writing this on a dotnet forum is testament that I am more a .net man than Sql man!). ... Whether I poll from SQL or from .net App, i MUST keep the .net App open for the duration of the poll in order to send the SMS and create the log. ...
    (microsoft.public.dotnet.languages.vb)
  • vb.net dataTbl can DTS read?
    ... What I would like to do is to have DTS ... in the app - memory table). ... able to do bulk data transfer from a .Net app to Sql ...
    (microsoft.public.sqlserver.dts)
  • RE: A couple of R2 Impressions
    ... I agree 110% with Ross M...why why why take away my DTS that I rely and works ... component or I can't use it...it is going to be hard enough to master SQL ... have concern over the decision to dramatically reduce functionality with the ... or good business for MS – it just alienates customers. ...
    (microsoft.public.windows.server.sbs)
  • Re: How do I run a .BAS file saved from a DTS package?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I have used DTS for import and export. ... > The DTS Designer is easy to understand and use. ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase Source. What "data flow source" to use?
    ... but could still use DTS to move data. ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)