SSIS PAckage using XML Connection

Posted by Anishabathija under Sql Server on 5/14/2013 | Points: 10 | Views : 795 | Status : [Member] | Replies : 0
hey I have an xml file ,

the format of which is something like this :

<xml ?.....................>
<name> anisha </name>
<class> 6 </class>
<id> 13 </id>
<date> xxxx </date>

now I want to extract the data anisha , 13 and 6 and pass these to my SP.
How should I go about it ?
Should I use a staging table where I copy the entire data into the table and then extract it in my SP. Or use a fixed length approach ?


(No response found.)

Login to post response