Excellent article, Dave, and the timing couldn't be better as I have recently been tasked with producing Server availability reports, which I will use TempDB creation date for.
I had already done the first three steps when I found your article. Steps 4 and 5 are straightforward, but I ran into a snag with Step 6 - Building the Server Query Loop. You say to add a For each Loop Container to the data flow work area, but the only Foreach Loop Container I can find are in the control flow items.
I was using BIDS 2008 and thought perhaps things got changed, so I tried the same thing with BIDS 2005, but the FeLC is in the same place. What am I missing?
Using the FeLC in the Control Flow, I had some problems initially. I don't have a lot of SSIS experience yet, and it took a lot of poking and prodding to find that Ihadto click on the words "Foreach File Enumerator" to see the pull down list where I found "Foreach ADO Enumerator" which then gave me the ADO object source variable window where I foung User::ServerList to select, as well as the radio buttons to select Rows in the frist table.
But it remains in my Control flow tab, not my Data flow tab. I'll see what happens in Step 7.
Again thanks for a super article.