The story of SSIS‑948 traveled across the organization, becoming a cautionary tale for every new ETL developer: . And whenever a red flag appeared in the logs, the team would whisper, “What would Jenna do?”—and then they would derive a solution.
Only were sent to the quarantine table—exactly those that still lacked any date information. The main fact table now held a clean set of rows ready for reporting.
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. ssis-948
Observability & Auditing
: Another common cause is specifying an incorrect or non-existent path for the checkpoint file. SSIS needs a valid path where it can create the checkpoint file. The story of SSIS‑948 traveled across the organization,
Jenna then ran a quick to see if any rows actually had a NULL OrderDate :
| Parameter | Default Value | Effect | |--------------------------|---------------|--------| | | 10 000 | Max rows per buffer | | DefaultBufferSize | 10 MB | Max memory per buffer | The main fact table now held a clean
A nightly package loads CSV files from a shared folder into a SQL Server table. The package fails with:
The result set was empty. Yet the error insisted a NULL was trying to sneak through.