Cloud SQL supports the SQL Server Integration Services (SSIS) component. SSIS doesn't need any configuration to work with Cloud SQL. It works with any managed SQL Server instance.
This page provides the prerequisites, limitations, and recommendations for using SSIS on Cloud SQL.
Before using SSIS on Cloud SQL, you must have the following:
- A host where you install and run Microsoft SQL Server Integration Services. It can be either a Compute Engine VM or a host that doesn't use Compute Engine. For installation instructions, see Install Integration Services (SSIS).
- If you plan to use Windows Authentication, you must use Managed Active Directory to join the SQL Server instance and the host running SSIS. For instructions, see https://cloud.google.com/sql/docs/sqlserver/configure-ad.
Cloud SQL doesn't support the SSISDB catalog. However, you can deploy SSISDB catalogs to a SQL Server instance that is not on Cloud SQL and manage them from there.
Cloud Data Fusion provides an interface that lets you deploy code-free ETL (extract, transform, load) and ELT (extract, load, transform) data pipelines. We recommend that your solution include ETL/ELT data pipelines because they provide a library of over 150 preconfigured connectors and transformations, with no additional cost. For more information about using Cloud Data Fusion with SQL Server, see Reading from a SQL Server table.
To learn how to author and execute SSIS packages, see Create a project and basic package with SSIS.