The error code "SSIS 948" doesn't provide much context on its own, as there are numerous error codes and events within SSIS. However, I'll provide some general guidance on troubleshooting and a useful report that might help.
While "SSIS" generally stands for , the "948" refers to the event instance rather than a version of the software. Key Highlight: SQLSaturday #948 ssis948 full
| Test ID | Source | Destination | Data Volume | Avg. Throughput (SSIS 9.2) | Avg. Throughput (SSIS 9.4.8) | % Improvement | |---------|--------|-------------|-------------|---------------------------|-----------------------------|---------------| | T‑01 | SQL Server 2019 | Azure Data Lake (Parquet) | 50 TB | 1.2 TB/h | 2.0 TB/h | +66 % | | T‑02 | Oracle 19c | Synapse Dedicated Pool | 30 TB | 0.9 TB/h | 1.6 TB/h | +78 % | | T‑03 | CSV (on‑prem) | Snowflake | 20 TB | 0.5 TB/h | 0.9 TB/h | +80 % | | T‑04 | CDC (SQL Server) | ADLS Gen2 (Delta) | 10 TB/day | 0.32 TB/h | 0.45 TB/h | +41 % | The error code "SSIS 948" doesn't provide much