Load XML Data Column in XML Data Source RRS feed

  • Question

  • I have a source table which has a column of type XML.
    I want to apply an XSLT on it, inside the SSIS package.

    When I try to read the XML column in the XML Data Source, I don't see an option to load the column in the data source. it can read a file, or a variable which contains the path or the data itself.

    I can pass the XML to a variable and then from there to the XMLData Source, but my fear is that the String Variable of SSIS might not be able to handle all the data of the XML Data type (2^31 - 1).
    Saturday, January 16, 2010 5:19 PM


  • String Variables in SSIS will be able to store that, easily.  You should be able to process it by passing the variable to the XML Data Source - but only if you don't use Expressions to get it there.  (I'm not familiar enough with the XML Source to know if it can directly reference a variable, or requires property expressions to do that.)  Expressions have a 4000 character result limit.

    Todd McDermid's Blog

    Saturday, January 16, 2010 11:47 PM