Building Better SSIS Packages
summary
Explains concrete practices: use catalog logging and environments for built-in audit and sensitive-parameter handling, enable checkpoints for restartability, prefer never write the same code twice (Mitchell’s law) and use BIML to generate hundreds of packages in 15 seconds instead of copy‑pasting, tune lookup cache mode and avoid select * for metadata, watch blocking transforms like merge join and sort, and choose rollback or graceful failure patterns based on data criticality (example: 30‑minute job that could be cut by a third but may not justify the work).
AI-written summary · about
chapters (9)
- 0:00Introduction and logistics
- 4:19Overview of SSIS design
- 5:59Package reliability
- 12:38Building resilient packages
- 23:37Reusability in ETL
- 28:45Maintainability and BIMEL
- 36:57Performance tuning
- 45:18Package security
- 50:52Q&A and wrap up
related talks
01h 12mAzure DevOps and the SSIS Development Lifecycle
36mHow to make your daily routine, code and database more efficient
01h 10mContinuous Integration for the BI Developer
43mPerformance Tuning, Getting the Biggest Bang for Your Buck
29mMaking tech boring to keep data exciting
48mApplying effective Source Control to your Database System
53mAzure DevOps and the SSIS Development Lifecycle
01h 02m10 Opinions For Creating More Maintainable .NET Apps