Microsoft SQL Server Integration Services をインストールして実行するホスト。Compute Engine VM でも、Compute Engine を使用しないホストでもかまいません。インストール手順については、Integration Services(SSIS)をインストールするをご覧ください。
Cloud Data Fusion には、コードフリーの ETL(抽出、変換、読み込み)と ELT(抽出、読み込み、変換)のデータ パイプラインをデプロイできるインターフェースが用意されています。このソリューションでは、150 を超える事前構成されたコネクタと変換のライブラリを追加費用なしで利用できるため、ETL / ELT データ パイプラインを含めることをおすすめします。Cloud Data Fusion と SQL Server の併用の詳細については、SQL Server テーブルからの読み取りをご覧ください。
[[["わかりやすい","easyToUnderstand","thumb-up"],["問題の解決に役立った","solvedMyProblem","thumb-up"],["その他","otherUp","thumb-up"]],[["わかりにくい","hardToUnderstand","thumb-down"],["情報またはサンプルコードが不正確","incorrectInformationOrSampleCode","thumb-down"],["必要な情報 / サンプルがない","missingTheInformationSamplesINeed","thumb-down"],["翻訳に関する問題","translationIssue","thumb-down"],["その他","otherDown","thumb-down"]],["最終更新日 2025-09-04 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)."]]