Cloud SQL supports theSQL Server Integration Services (SSIS) component. SSIS doesn'tneed any configuration to work with Cloud SQL. It works with any managedSQL Server instance.

This page provides the prerequisites, limitations, and recommendations for usingSSIS on Cloud SQL.

Prerequisites

Before using SSIS on Cloud SQL, you must have the following:

1. 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, seeInstall Integration Services (SSIS).
2. If you plan to use Windows Authentication, you must use Managed ActiveDirectory to join the SQL Server instance and the host running SSIS. Forinstructions, seehttps://cloud.google.com/sql/docs/sqlserver/configure-ad.

Limitations

Cloud SQL doesn't support the SSISDB catalog. However, you candeploy SSISDB catalogs to a SQL Server instance that is not on Cloud SQLand manage them from there.

Recommendations

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 theyprovide a library of over 150 preconfigured connectors and transformations, withno additional cost. For more information about using Cloud Data Fusion withSQL Server, seeReading from a SQL Server table.

What's next

To learn how to author and execute SSIS packages, seeCreate a project and basic package with SSIS.