How to Insert below tyoe of XML Data into SQL Table




<?xml version="1.0" standalone="true"?>

-<SymCLI_ML>


-<Symmetrix>


-<Symm_Info>

<symid>000195700677</symid>

</Symm_Info>


-<Initiator_Group>


-<Group_Info>

<group_name>IG_TK3-CU-SV-FA001</group_name>

<last_updated>08:47:56 PM on Sat Dec 28,2013</last_updated>

<group_last_update_time>08:47:56 PM on Sat Dec 28,2013</group_last_update_time>


-<Initiators>

<wwn>10000090fa029715</wwn>

<user_node_name>10000090fa029715</user_node_name>

<user_port_name>10000090fa029715</user_port_name>

<wwn>10000090fa029714</wwn>

<user_node_name>10000090fa029714</user_node_name>

<user_port_name>10000090fa029714</user_port_name>

</Initiators>


-<Initiator_List>


-<Initiator>

<wwn>10000090fa029715</wwn>

<user_node_name>10000090fa029715</user_node_name>

<user_port_name>10000090fa029715</user_port_name>

</Initiator>


-<Initiator>

<wwn>10000090fa029714</wwn>

<user_node_name>10000090fa029714</user_node_name>

<user_port_name>10000090fa029714</user_port_name>

</Initiator>

</Initiator_List>


-<Device>

<dev_name>1405</dev_name>

<director>01E</director>

<port>1</port>

<pd_name>Not Visible</pd_name>

<host_lun>0</host_lun>

<attr>Meta Head</attr>

<capacity>52613550</capacity>

<view_name>MV_TK3-CU-SV-FA</view_name>

</Device>


-<Device>

<dev_name>1405</dev_name>

<director>02E</director>

<port>1</port>

<pd_name>Not Visible</pd_name>

<host_lun>0</host_lun>

<attr>Meta Head</attr>

<capacity>52613550</capacity>

<view_name>MV_TK3-CU-SV-FA</view_name>

</Device>


-<Device>

<dev_name>1405</dev_name>

<director>03E</director>

<port>1</port>

<pd_name>Not Visible</pd_name>

<host_lun>0</host_lun>

<attr>Meta Head</attr>

<capacity>52613550</capacity>

<view_name>MV_TK3-CU-SV-FA</view_name>

No comments:

Post a Comment