Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2003

    Lightbulb Unanswered: Need help with DTS script

    Hey All,

    I have this dts script that is scheduled to import xml files from a directory into SQL 2000, the script is running well but if an xml file contains new information it crashes or if some lines are not available in the xml file it crashes.

    I want to know if there are lines not available in the xml file that the script continues with the rest and ignore the misiing part.

    I also want to know that if there is a node in the xml file it creates a new table into the sql server.

    I attached the dts script to this post.

    I hope that someone can help me!!

    Thanx and cheers Wimmo
    Attached Files Attached Files

Posting Permissions

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