It has to be off hours and be a point-in-time restore scenario - so I can't really use transactional rep.

I've thought about using bcp?

Thanks for detailed reply - I will double check these.

Unfortunately I get the same error:

I think this is the line it doesn't like:

((TargetInstance.freespace/TargetInstance.size) * 100) < 10

but you can use a similar syntax in SSIS / WMI Connections?

Apologies - typo - the exact statement is:

SELECT * from __InstanceModificationEvent

WITHIN 30

WHERE

TargetInstance ISA 'Win32_LogicalDisk'

AND

((TargetInstance.freespace/TargetInstance.size) * 100) < 10

AND

TargetInstance.DeviceID = 'Y:'

The error is:

SQLServerAgent Error: WMI Error: 0x80041058

The @wmi_query could not be executed in the @wmi_namespace provided. Varify that an event class selected in the query exists in the namespace and...

Yes I agree.

Does anyone then know of a way to point different Data Collector sets at different mdw databases. For example I want the UCP data to go to the...

Thanks for the confirmations!

It seems that running both sends stuff to the sysutility_mdw database:

http://blogofshaw.blogspot.com.au/2011/06/microsoft-sql-servers-ucp-utility.html