CODEWITHSUNDEEP
c#sql-serverxmlazuressis
Faraday
Faraday

Reputation: 2954

XML To Custom SQL Tables

I have a large XML data feed (5GB) dropped to me daily (I need to get it via HTTP). This feed is a representation of some tables which are too complex for my needs, I want to trim them down as much as possible. I have refined the table design to include only what I absolutely need, but I am not sure of what the quickest technology would be.

I am doing this in Azure, using C# .NET 4.5 and using SQL Server (2012 if my memory is correct). I would expect SSIS to be the best option, but I do not believe Azure supports it at the moment. If it does (I can't find any docs to support this), could you point me towards some examples/documentation?

Thanks!

Upvotes: 0

Views: 109

Answers (1)

Brendan Green
Brendan Green

Reputation: 11914

You could upload the XML data feed into Azure Table Storage, and then process it via a web job (see: http://www.windowsazure.com/en-us/documentation/articles/web-sites-create-web-jobs/).

Since you mention that you receive a daily feed, Web Jobs can be scheduled.

Upvotes: 1

Related Questions