On-premises SSIS data engineering pipeline integrating DB2/AS400 source systems through ODBC and ADO.NET connectivity layers into SQL Server Data Warehouse. SSIS Packages orchestrated via SQL Server Agent scheduler and PowerShell scripts execute ETL transformations stored in SSISDB Catalog, with DTExec.exe handling package execution and runtime monitoring. Data Quality Service validates warehouse data while Monitoring System tracks agent logs and pipeline health, feeding consumption through Business Portal web application. This architecture demonstrates enterprise data integration patterns for organizations modernizing legacy mainframe systems without cloud migration. Fork and customize this diagram to document your own on-premises ETL topology, connectivity strategies, and scheduling workflows.