Post reply

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

  • October 11, 2014 at 5:05 pm

    #294112

    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

  • October 11, 2014 at 9:58 pm

    #1751839

    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.

    😎

  • October 28, 2014 at 3:18 am

    #1755127

    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.

    😎

    Thanks SSCrazy. Sorry for the delay in responding but I was on holiday. I'll give it a go and report back.

    Dave

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

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