Good on you Brandie,

Please dont let me stop you publishing good stuff to the community just cos I am a stick-in-the-mud. If SSIS has the magic bullet then I for one would be...

I use a batch file that runs as a Sheduled Task ... remember the good old days of DOS? I used to pride myself on getting every application onto a single 3.5"...

Not happy with using SSIS packages, too much admin. Why bother anyway when the good old guys from the Linux world provide such excellent GNU utilities like WGet? (Open source...

The table join was just a neat way to pivot the table. If you look at the output from OPENXML you will see it is just a tag order linked list...

Cheers for your response Brandie,

Have already explored these avenues. After several hours of effort, eventually settled on the following solution.  Note, I had to WGet the file to a local...