Import XML data into Database

1) Open XML file into Excel (file > Open)
2) It will display Open XML dialog select "Use The XML Source task Pane"
3) Select Ok
4) It will XML schema on left side
5) Drag the XML schema to data area
6) save the Excel workbook as a template
7) open template workbook
8) right click on 1st cell
9) select import XML
10) give the source XML file
11) it will import only matching schema data.

using reflection to read nullable columns - type casting

CLICK HERE

BI learning

virtual lab

Click Here

WebCasts

Click here

Learn Microsoft BI
Click here


Pragmetic Works
Click here

Microsoft Webcaset series
Click here

finding deals online

Finding deals online

CLICK HERE

to protect your home wifi

protect your home wifi

Click here

good site

CLICK HERE

good site

CLICK HERE