Hi Michael ,

All valid questions,

How sparse is it?

All fields in the matrix would be populated the number of columns could vary widely on a daily basis .day1 1200 cols,...

Thanks Michael,

I have no prior knowledge of datawarehousing so I'll read up on your suggestion. I'm working my way through the SSIS loading mechanism now.

Thanks to everybody for your help and...

Thanks Markus,

Would there be a big overhead in then converting the xml datatype to columns and rows , once I had it in the db as xml? is it possible to...