Part 1: http://www.sqlservercentral.com/articles/XML/87539/

Part 2: http://www.sqlservercentral.com/articles/XML/87685/

Part 3: http://www.sqlservercentral.com/articles/XML/87637/

In Part 4, I show how to stream an XML invoice which has multiple parent-child hierarchies very similar to what you are talking about. In Part 5 I show how...

Part 1 can be found here: http://www.sqlservercentral.com/articles/XML/87539/

Part 2 can be found here: http://www.sqlservercentral.com/articles/XML/87685/

I'm sure your way is more efficient, but I was not really focused on the most efficient way to do things when writing this tutorial.

I was interested in demonstrating...

My bet is that during the course of a year they lose some through mergers, bankruptcies, etc. and have to replace them. It may take a while to find suitable...

I got the data file from EODDATA.

http://www.eoddata.com/

You will have to ask them.

The first five articles in this series were accepted before any of them were published. I don't know the URL of a published article until it is actually published. ...

The next article in this series will show you how to write an SSIS package that performs XSLT transformations.

It will be published next Wednesday.

"1 - the solution shown does not use SQL server to solve the problem, nor can it be automated, so it is often not usable for your target audience, sql...

You did what I meant to do. Thanks.

XML is not as easy as advertised.

using Microsoft.VisualBasic;

using System;

using System.Collections;

using System.Collections.Generic;

using System.Data;

using System.Diagnostics;

using System.IO;

using System.Math;

using Microsoft.SqlServer.Dts.Runtime;

namespace ST_ac77e2644b9b4a1090164b90072fd897.csproj

{

[System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]

public partial class...

To be honest, the only reason I wrote this is because somebody responding to one of my previous articles asked how it could be done.

Just because something can be done...

@bhavjay

To me, a staging table is just that, the first stage of processing the data.

Since we don't really know what kind of data the fields are going...

That's some really nice code.

I just wrote mine to show that the idea would work.

Yours would work well.

Thanks!