Source table has an xml column that I need to query before splitting into 2 tables

  • 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

  • Duplicate topic, answer here

    😎

  • I did try to delete this topic as it was a duplicate but couldn't find the button!

  • dcarter 43846 (10/12/2014)


    I did try to delete this topic as it was a duplicate but couldn't find the button!

    No worries;-)

    😎

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply