Results 1 to 2 of 2

Thread: XML directly into DTS

  1. 09-11-2000, 03:12 PM #1
    Bo Graham Guest

    XML directly into DTS


    Hello, It seems to me that there should be a way to feed straight xml to DTS and have it populate tables. Has anyone done this? Specifically I was thinking of feeding a WDDX variable requlting from a query into it.

    Thank you,
    Bo Graham
    Reply With Quote Reply With Quote
  2. 09-12-2000, 12:28 PM #2
    Chris Guest

    XML directly into DTS (reply)

    If you are using SQL 7, you have to customize the transformation to use the (XML DOM) and ADO to interact with the DB.

    SQL 2000 supports this natively with the OPENXML() function.


    ------------
    Bo Graham at 9/11/00 4:12:01 PM


    Hello, It seems to me that there should be a way to feed straight xml to DTS and have it populate tables. Has anyone done this? Specifically I was thinking of feeding a WDDX variable requlting from a query into it.

    Thank you,
    Bo Graham
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules