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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!