Stay organized with collectionsSave and categorize content based on your preferences.
Cloud SQL supports theSQL 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.
Prerequisites
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, seeInstall Integration Services (SSIS).
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.
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 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, seeReading from a SQL Server table.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-03 UTC."],[],[],null,["# SQL Server Integration Services (SSIS)\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\nCloud SQL supports the [SQL Server Integration Services (SSIS)](https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver16) component. SSIS doesn't\nneed any configuration to work with Cloud SQL. It works with any managed\nSQL Server instance.\n\nThis page provides the prerequisites, limitations, and recommendations for using\nSSIS on Cloud SQL.\n\nPrerequisites\n-------------\n\nBefore using SSIS on Cloud SQL, you must have the following:\n\n1. 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)](https://learn.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-ver16).\n2. 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 \u003chttps://cloud.google.com/sql/docs/sqlserver/configure-ad\u003e.\n\nLimitations\n-----------\n\nCloud SQL doesn't support the SSISDB catalog. However, you can\ndeploy SSISDB catalogs to a SQL Server instance that is not on Cloud SQL\nand manage them from there.\n\nRecommendations\n---------------\n\nCloud Data Fusion provides an interface that lets you deploy code-free ETL\n(extract, transform, load) and ELT (extract, load, transform) data pipelines.\nWe recommend that your solution include ETL/ELT data pipelines because they\nprovide a library of over 150 preconfigured connectors and transformations, with\nno additional cost. For more information about using Cloud Data Fusion with\nSQL Server, see\n[Reading from a SQL Server table](https://cloud.google.com/data-fusion/docs/how-to/reading-from-sqlserver).\n\nWhat's next\n-----------\n\nTo learn how to author and execute SSIS packages, see\n[Create a project and basic package with SSIS](https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-create-a-project-and-basic-package-with-ssis)."]]
