Sunday, 1 February 2015

importing xml / csv file in web from SQL Server 2012



I am building a data-mart in SQL Server 2012 which intends to support some data analysis for users. One of my data source is from a .gov website which is publicly available. It is hosted in two formats .xml and .csv


http://ift.tt/1CQoboc


http://ift.tt/1wTML0J


What is the best way I could import the data into my SQL server? Please note, I am very new to .xml data sources.


No comments:

Post a Comment