Results 1 to 2 of 2

Thread: DTS from XML

  1. #1
    Join Date
    Sep 2005
    Posts
    21

    Unanswered: DTS from XML

    Does anyone know how to create a dts package that will take a XML document and import the contents to a new table in sql.

    I have looked in the tasks of DTS and cannot find the xml connection.

    Any pointers to some samples would be great.

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Consider upgrading to SQL Server 2005, which has extended support for XML including data import through the Integration Services application. (Interestingly, Integration Services does NOT export XML. Go figure...).
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •