Unanswered: DTS Exception error in Profiler. Help!
I'm doing a large DTS operation across systems and it is going REALLY slowly. This has been running over 24 hours. The disc is constantly pegged at 100% usage and I don't see any reason why it should be.
There are no recent entries in the "SQL Server Logs". I started a profile and am watching for data file grows, log file grows, and exceptions. I get lots of exception records with application name "DTS Designer". TextData is:
Error: 911, Severity: 16, State: 1
I've looked through BOL and Google and I can't find anything on diagnosing these errors. Any ideas?