1
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 [...]
Answer Question
| July 1, 2009 7:44 PM
SQL, SQL Tasks, SSIS, SSIS 2005, XML
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 [...]
Answer Question
| July 1, 2009 7:44 PM
SQL, SQL Tasks, SSIS, SSIS 2005, XML
1
