Several factors can lead to the occurrence of SSIS-885:
These forces culminated in the IDISC working group’s decision to produce a pragmatic, implementable standard—SSIS‑885—that could be adopted incrementally while delivering immediate risk mitigation. SSIS-885
| Item | Description |
|------|-------------|
| Identifier | SSIS‑885 – a Microsoft‑internal feature‑request/bug‑ID that introduced “Unified Execution Logging to Azure Monitor (Log Analytics)” for SQL Server Integration Services packages. |
| Goal | Give developers and operations teams a single, searchable, real‑time view of every SSIS package execution – whether the package runs on‑prem, in an Azure‑SQL Managed Instance, or inside an Azure‑DataFactory (ADF) SSIS Integration Runtime (IR). |
| Why it matters |
|
| Supported runtime versions | • SQL Server 2016 SP2 and later (including SQL Server 2022)
• Azure‑SSIS Integration Runtime (v2 and later) |
| Prerequisites |
| Several factors can lead to the occurrence of
| Deployment Model | Description | Typical Use‑Case | |------------------|-------------|------------------| | On‑Premises Appliance | Dedicated VM or bare‑metal box running the SSIS‑885 runtime. | Highly regulated sectors (banking, defense). | | Kubernetes‑Native Operator | Containerized runtime deployed as a Helm chart, leveraging native CRDs for pipelines. | Cloud‑native micro‑service architectures. | | Serverless Function-as-a-Service | Pipelines expressed as a series of serverless functions (e.g., AWS Lambda, Azure Functions) with a lightweight SSIS‑885 shim. | Event‑driven, cost‑optimized workloads. | | Hybrid Edge‑to‑Core | Edge agents perform preprocessing, securely forward data to a central core runtime. | IoT / IIoT scenarios with low‑latency requirements. | | Item | Description | |------|-------------| | Identifier
The specification defines neutral APIs (RESTful, gRPC, and OpenAPI) to ensure interoperability across these deployment models.
All events land in a custom Log Analytics table called SSISExecution_CL. Below are the most common queries you’ll need.