| Tool | How to Enable | |------|---------------| | (SQL Server, Text file, Windows Event Log) | In the package designer → SSIS → Logging → check OnPreExecute , OnError , OnTaskFailed , OnWarning . Include SourceName , SourceID , MessageText , DataBytes . | | SQL Server Profiler / Extended Events | Trace Error events on the target instance. Look for Error 20 , Error 18456 , etc., that coincide with the SSIS‑913 timestamp. | | Performance Monitor (PerfMon) | Monitor SQLClient:Network Interface counters (e.g., TCP Connections , Bytes Sent/Received ). Spikes often correlate with intermittent failures. | | System Event Viewer | Check Application and System logs for network adapter resets, VPN disconnects, or Kerberos errors. |
Solution:
the data flow’s metadata and the actual schema of the upstream source are out of sync. SSIS-913