Ssis927 Full ((exclusive)) Jun 2026

: The production also features Isedon Uchimura and Muscle Sawano.

| NFR # | Description | Target | |-------|-------------|--------| | | Performance – Full load of up to 200 M rows (≈ 150 GB) must complete within 4 hours on the standard Azure‑SQL‑DW tier. | Must | | NFR‑2 | Scalability – Batch size can be increased up to 100 k rows without code change. | Should | | NFR‑3 | Reliability – Success rate ≥ 99.5 % across all scheduled runs (including retries). | Must | | NFR‑4 | Security – No clear‑text credentials in package; use Azure Key Vault / SSISDB protection level EncryptSensitiveWithUserKey . | Must | | NFR‑5 | Observability – Metrics: LoadDuration , RowsProcessed , RowsFailed , ArchiveCount . Exported to Azure Monitor. | Must | | NFR‑6 | Maintainability – Package code < 2 k lines, fully commented, with unit‑testable script components. | Should | | NFR‑7 | Compliance – All data movement must be logged for GDPR audit (who, when, what). | Must | | NFR‑8 | Backup/Recovery – Archive tables are backed up as part of the standard DB backup schedule (daily). | Must | ssis927 full

Change data types to match the destination. Lookup: Check if a record already exists. : The production also features Isedon Uchimura and