SSIS connection
=================

Field reference: :doc:`../providers/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.

.. TODO: screenshot of the empty Connections list with the "+" button
   highlighted

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

.. TODO: screenshot of the Connection Type dropdown with Microsoft SQL
   Server selected

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

.. TODO: screenshot of the filled-in mssql connection form before Save