Ssis-440

Infrastructure & Deployment

| Layer | Description | Typical Use‑Case | |-------|-------------|-----------------| | | Orchestrates tasks (Execute SQL, Script Task, Data Flow, ForEach Loop). | Conditional branching, looping, package‑level logging. | | Data Flow | The “engine” that moves rows from sources → transformations → destinations. | Bulk load, cleansing, aggregation, lookup, fuzzy matching. | | Connection Managers | Centralized objects that hold connection strings & credentials. | Reuse across tasks; switch environments via project parameters. | | Parameters / Variables | Runtime‑modifiable values (Project, Package, Task‑level). | Deploy‑time configuration, environment‑specific values, user‑input. | | SSIS Catalog (SSISDB) | Dedicated database that hosts project deployment model packages, execution logs, and environments. | Centralized monitoring, versioning, and security. | SSIS-440

: Regular backups of the SSISDB database are required to preserve projects, packages, and environment settings. Infrastructure & Deployment | Layer | Description |