Hi David,
Tried your SSIS package. Brilliant idea. However, I got an error message ( or warning ... I am not quite sure since the package did deliver the result but in Excution Result window, I noticed there are few red marks...)
[Execute SQL Task] Error: Failed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection.
Task Get ErrorLog failed
Progress: Executing query "-- Drop Temporary Tables
IF OBJECT_ID('tempdb..#E...". - 50 percent complete
Not quite sure what the reason behind this. The connect use DBA account. So, I guess there shouldn't be any previlidge issue. Any idea?