Post reply

SSIS Script Task

  • August 11, 2008 at 11:01 am

    #196946

    Hi,

    I have a string variable which holds a well formed XML string from the database. I want to write this out to a file. In the script task i have the following code:

    System.Xml

    Dim docXML AS XmlDocument AS New XmlDocument

    docXML.LoadXml(sXml)

    docXML.Save("C:\test.xml")

    I get an error saying the definition of docXML is not valid. Any thoughts on this

    Thank you

  • August 12, 2008 at 3:05 am

    #856543

    why not use the XML task?

    Life: it twists and turns like a twisty turny thing

  • August 12, 2008 at 7:13 am

    #856653

    Nothing wrong with what you are doing. How sure are you that it is valid xml. msgbox it? Write it to text file and see. If the DOM is complaining that it is invalid XML, it probably is.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • August 12, 2008 at 7:16 am

    #856662

    Thanks for the reply. I am getting an error at the definition of docXML itself, i get squiggly lines under the XmlDocument, at the Dim Statement. When I do DocXML. I do not see any intellisense come up.

    Thank you

  • August 12, 2008 at 7:21 am

    #856668

    Top of your code you must have Imports System.xml

    Alos, Menu > Project > References > System.xml

    That should do it.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply