sudhirr
New Contributor II

Yes, it is possible to integrate SSIS packages with Delta tables using JDBC/ODBC connectivity.

Required on Databricks side:

  • SQL Warehouse or interactive cluster
  • JDBC/ODBC driver
  • Hostname, HTTP Path, Port 443, and PAT token
  • Proper table permissions in Unity Catalog

Recommended approach:
SSIS → JDBC/ODBC → Databricks SQL Warehouse → Delta Tables

For better performance, use batch/bulk loads instead of row-by-row inserts.
In modern architectures, many teams use SSIS for orchestration and move heavy transformations to Databricks notebooks, Lakeflow, or ADF.