MSSQL2k retrive data from xml

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

Hello
I have mssql 2k there database and few XML files. I try get data from XML files and insert into database. How to do that using DTS??


AJA

.

Relevant Pages

  • Re: SQLXMLBulkLoad Question (Please help)
    ... Are you confirming that this is a bug in XmlBulkload? ... corporate database to multiple remote client databases. ... file generated for each table and these xml files are zipped ... dataset also contains correct values for nulls, empty strings and spaces. ...
    (microsoft.public.sqlserver.xml)
  • Re: general archetecture questions.
    ... > first app i'm writing will be using XML as a database of sorts, using> dataset and dataview and wrapped up in a set of classes. ... in the past i used> ".getinstance" in java to get a single instance of a class contained in a application variable to ensure i dont have 3-4> different instances hitting the database and worse now writing 3-4 different> xml files. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: xml, sql mobile and server 2005
    ... I have a Windows Mobile application that uses a database. ... this works great and I get some nice xml files on mp mobile device. ... Depending on whether schema info is included on the wm5 side, ... CONSTRAINT PRIMARY KEY CLUSTERED ...
    (microsoft.public.sqlserver.xml)
  • Re: Windows forms application and database back-up
    ... But setting it back to the database needs all kind of creation, ... What if you created a function that created a "Select * from Table" for all tables and wrote that to multiple XML files. ... attached to the SQL Server instance), ... The other option would be to use SQL Server Express' USER INSTANCE, to which, the user do not have to have local admin rigth to attach database to SQL Server Express instance. ...
    (microsoft.public.dotnet.general)
  • Re: Database programminf question...
    ... Does writing the data to the XML files on the laptop retain the ... files allowing them to be read back in without loosing any database ... the laptop SQL instance in a way that would allow using the DataSet/ ...
    (microsoft.public.dotnet.languages.csharp)