SSIS connection

Field reference: airflow-ssis-provider. A standard Airflow mssql connection (Airflow’s built-in Microsoft SQL Server type) pointed at the SQL Server instance hosting the SSISDB catalog — no provider-specific connection type.

Steps

  1. In the Airflow UI, open Admin → Connections, then click + to add a new connection.

  1. Set Connection Id (e.g. ssis_default, matching whatever conn_id your DAGs pass to SsisPackageOperator/ SsisPackageSensor) and Connection Type to Microsoft SQL Server.

  1. Fill in Host, Schema (the SSISDB catalog database), Login, and Password for the SQL Server instance, then click Save.