• quillis131 (2/14/2013)


    Goal : Need to pull data from XML file (800MB).

    Note: I tried to do with XML task and XSLT but couldn't make it work, it gives me an Out of Memory expection error.

    http://beyondrelational.com/modules/2/blogs/106/posts/11130/ssis-read-xml-file-in-script-component-as-source.aspx

    I end up searching above link.

    Issues : I can't get this to work either. My script task complaints me when I try to AddRow() function, (Please go throw the link if you can understand C# )

    Script complaints "doesnot contain definition and no extension method can be found (are you missing a using directive or an assembly reference?)"

    Help need: Plz suggest me a solution to read data frm XML either through new process or Please guide me to help out of this error thrown while writing C# script (in the link above).

    I can understand C# and read the link, which presumably is a working solution.

    I would guess that either:

    a) The Script Component config has been set up wrongly, or

    b) Your C# code has one or more syntax errors

    but guesswork is as far as I can go without more info.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.