Lenevo
Pilla Bewarse Username: Lenevo
Post Number: 940 Registered: 05-2011 Posted From: 65.74.157.84
Rating: N/A Votes: 0 | Posted on Wednesday, March 26, 2014 - 10:30 pm: | |
fIRST STRIP OFF THE XML BASED ON SEGMENTS AND THEN ATTRIBUTES .. SO A SINGLE SEGMENT CAN HAVE MULTIPLE ATTRIBUTES ( FIELDS IN YOUR DB).. AND THEN PROCESS IN TO A TABLE . THIS CAN BE CALLED AS STAGING TABLE, AND THEN PROCESS FROM THERE.. ITS AS COMPLICATED AS YOU THINK.. SEARCH GOOGLE OR BING WITH XML_DOCUMENT.. fyI, DONT USE SSIS PACKAGE. IT WILL GIVE WRONG RESULTS THOUGH YOU SPECIFY XSD. |