Why is SSIS xml variable in escaped format?
5 pts.
0
Q:
Why is SSIS xml variable in escaped format?
In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote marks are escaped ("). I've tried both the OLEDB and the ADO.net connection managers. I want to pass the xml result to a web service using the Script task. My question is do I need to get rid of those escaped doublequotes first OR how can I avoid them in the first place OR does the script task silently handle this? I just do not understand why SSIS messes with xml when I tell it the resultset must be in xml format even though I'm storing it in a string variable. Please be so kind to educate me. Thank you.
ASKED: Jul 1 2009  7:44 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
5 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Jul 1 2009  7:44 PM GMT by PaulDav   5 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0