locked
Mapping of an xml column to variable RRS feed

  • Question

  • I have a For Each Loop that iterates over a recordset stored in a variable.  One of the columns in the recordset is type xml and I want to map it to a variable using Variable Mappings of the For Each Loop container.  I am getting this error:

    Error: 0xC001C012 at FELC Loop thru report defs: ForEach Variable Mapping number 4 to variable "User::Parameters_xml" cannot be applied.

    I have tried changing the type of the Parameters_xml variable to Object and String, but I get the same error.  Any ideas?

    Wednesday, August 23, 2006 10:27 AM

Answers

  • I tried casting the xml-typed column to varchar(8000) and then it worked.
    Thursday, August 24, 2006 9:49 AM

All replies

  • you can try using a script task instead.
    Thursday, August 24, 2006 7:25 AM
  • I tried casting the xml-typed column to varchar(8000) and then it worked.
    Thursday, August 24, 2006 9:49 AM