运行部署在 Azure 中的 SQL Server Integration Services (SSIS) 包Run SQL Server Integration Services (SSIS) packages deployed in Azure

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

可以通过选择本文介绍的某个方法,运行部署到 Azure SQL 数据库服务器上 SSISDB 目录中的 SSIS 包。You can run SSIS packages deployed to the SSISDB Catalog on an Azure SQL Database server by choosing one of the methods described in this article. 可以直接运行包,或将包作为 Azure 数据工厂管道的一部分运行。You can run a package directly, or run a package as part of an Azure Data Factory pipeline. 有关 Azure 上 SSIS 的概述,请参阅在 Azure 中部署和运行 SSIS 包For an overview about SSIS on Azure, see Deploy and run SSIS packages in Azure.

备注

通过 dtexec.exe 运行包的操作尚未经过部署到 Azure 的包的测试。Running a package with dtexec.exe has not been tested with packages deployed to Azure.

使用 SSMS 运行包Run a package with SSMS

在 SQL Server Management Studio (SSMS) 中,可以右键单击部署到 SSIS 目录数据库 (SSISDB) 的包,并选择“执行”以打开“执行包”对话框 。In SQL Server Management Studio (SSMS), you can right-click on a package deployed to the SSIS Catalog database, SSISDB, and select Execute to open the Execute Package dialog box. 有关详细信息,请参阅使用 SQL Server Management Studio (SSMS) 运行 SSIS 包For more info, see Run an SSIS package with SQL Server Management Studio (SSMS).

使用存储过程运行包Run a package with stored procedures

在可连接到 Azure SQL 数据库并运行 Transact-SQL 代码的任何环境中,可以通过调用以下存储过程来运行包:In any environment from which you can connect to Azure SQL Database and run Transact-SQL code, you can run a package by calling the following stored procedures:

  1. [catalog].[create_execution][catalog].[create_execution]. 有关详细信息,请参阅 catalog.create_executionFor more info, see catalog.create_execution.

  2. [catalog].[set_execution_parameter_value][catalog].[set_execution_parameter_value]. 有关详细信息,请参阅 catalog.set_execution_parameter_valueFor more info, see catalog.set_execution_parameter_value.

  3. [catalog].[start_execution] .[catalog].[start_execution]. 有关详细信息,请参阅 catalog.start_executionFor more info, see catalog.start_execution.

有关详细信息,请参阅以下示例:For more info, see the following examples:

使用脚本或代码运行包Run a package with script or code

在可以调用托管 API 的任何开发环境中,可以通过调用 Microsoft.SQLServer.Management.IntegrationServices 命名空间中 Package 对象的 Execute 方法,运行包。In any development environment from which you can call a managed API, you can run a package by calling the Execute method of the Package object in the Microsoft.SQLServer.Management.IntegrationServices namespace.

有关详细信息,请参阅以下示例:For more info, see the following examples:

使用“执行 SSIS 包”活动运行包Run a package with the Execute SSIS Package activity

有关详细信息,请参阅在 Azure 数据工厂中使用“执行 SSIS 包”活动运行 SSIS 包For more info, see Run an SSIS package using the Execute SSIS Package Activity in Azure Data Factory.

使用“存储过程”活动运行包Run a package with the Stored Procedure activity

有关详细信息,请参阅在 Azure 数据工厂中使用存储过程活动运行 SSIS 包For more info, see Run an SSIS package using stored procedure activity in Azure Data Factory.

后续步骤Next steps

了解用于计划部署到 Azure 的 SSIS 包的选项。Learn about options for scheduling SSIS packages deployed to Azure. 有关详细信息,请参阅计划 Azure 中的 SSIS 包For more info, see Schedule SSIS packages in Azure.