read a user variable in the data flow tab

• steve.petruso

  SSC Veteran

  Points: 235

  More actions

  August 23, 2011 at 5:13 pm

  #246860

  I have a user var (v_XMLvalue) which contains an xml string. What object can/should I use in the data flow window to read the user var and load to a sql db as an xml type? I tied the script component, but no joy.

  Thanks in advance.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  August 24, 2011 at 7:26 am

  #1372548

  You should use the script component as a source. Make sure you put the result in rows and put them into the output buffer of the script component.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP