Almost got this working now:
I used a script component as a source to access the details in the data in the ADO record set.
However, one problem still remains.
Once I have read in each server in the For Each Loop Container Server Quer
the WMI Query is executed.
I've set the properties for the WMI Data Reader Task as follow:
OutputType: Data Table
OverwriteDestination: Append to Destination
iskUsageResults is a package level varaible of type object.
.... the remaining issue is that once the WMI query runs, it then executes the script component and Dataflow.
I have to do a for each loop container after each WMI Query in order to get the details out to the OLE destination.
Why does the WMI Data reader 'replace' the ADO table despite me setting the OverwriteDestination to Append to Destination?
MCITP: Business Intelligence Developer (2005)