Eirikur Eiriksson (10/11/2014)

---

dcarter 43846 (10/11/2014)

---

Hi

I have a source table with an xml column that I need to query on the nodes and then depending on what data is in the node then to split it into 2 different tables. I don't think I can use conditional split so I am looking at just a straight Execute SQL Task. Has anyone got any ideas on any other way of doing this?

Thanks for the help in advance.

Dave

Quick thought, use an XQuery to bring in the relative content from the XML along with the table's content and run this through a conditional split.

😎