Bulk load operations can leave large amounts of unused space
It read:
JAV Scene Analyst Date: October 26, 2023 SSIS-692
| Target | CU / Patch | Release Date | What It Fixes | |--------|------------|--------------|---------------| | SQL Server 2019 | | 2023‑08‑15 | Resolves the metadata‑mismatch bug for mixed Unicode/non‑Unicode flows. | | SQL Server 2022 | CU 5 | 2024‑01‑22 | Updates the OLE DB provider to correctly expose DBTYPE_WSTR for nvarchar columns. | | Azure‑SSIS IR | v2.8 | 2025‑04‑09 | Aligns Azure‑SSIS runtime with the same fix. | Bulk load operations can leave large amounts of
In modern SQL Server versions, bulk load operations (like those performed by SSIS) automatically bypass looking for free space in existing pages to speed up the process. This can lead to: | In modern SQL Server versions, bulk load
Microsoft’s internal tracking label was first logged in Q2 2017 and officially closed in Q3 2023 with a fix shipped in CU 13 for SQL Server 2019 and CU 5 for SQL Server 2022 . However, many on‑premise installations still run older CUs, or have applied selective patches that left the underlying problem unaddressed.