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?
|