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.
July 1, 2009 7:44 PM
July 1, 2009 9:13 PM