I’ve written about Data Integration Lifecycle Management (DILM) tiers. To summarize, every enterprise needs at least four lifecycle management tiers: 1. Development – an environment in which developers have sysadmin privileges. 2. Test – another environment in which developers have sysadmin privileges. 4. Production – managed by production operations such as domain administrators, system administrators, …
Continue reading How to Promote SSIS Code in the Enterprise Lifecycle
Category:Software Engineering
On Over-Engineering…
Some who follow me on Twitch (you may follow me at https://twitch.tv/andyleonard) – have seen me live-code the demo project for the second edition of Building Custom Tasks for SQL Server Integration Services (link to the first edition). The demo project is a custom task named Execute Catalog Package Task: While writing about parsing the …
Continue reading On Over-Engineering…