Run SQL Server Integration Services (SSIS) packages deployed in Azure

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

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. You can run a package directly, or run a package as part of an Azure Data Factory pipeline. For an overview about SSIS on Azure, see Deploy and run SSIS packages in Azure.

• Run a package directly

  • Run with SSMS

  • Run with stored procedures

  • Run with script or code

• Run a package as part of an Azure Data Factory pipeline

  • Run with the Execute SSIS Package activity

  • Run with the Stored Procedure activity

Note

Running a package with dtexec.exe has not been tested with packages deployed to Azure.

Run a package with SSMS

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. For more info, see Run an SSIS package with SQL Server Management Studio (SSMS).

Run a package with stored procedures

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]. For more info, see catalog.create_execution.

2. [catalog].[set_execution_parameter_value]. For more info, see catalog.set_execution_parameter_value.

3. [catalog].[start_execution]. For more info, see catalog.start_execution.

For more info, see the following examples:

• Run an SSIS package from SSMS with Transact-SQL

• Run an SSIS package from Visual Studio Code with Transact-SQL

Run a package with script or code

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:

• Run an SSIS package with PowerShell

• Run an SSIS package with C# code in a .NET app

Run a package with the Execute SSIS Package activity

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

For more info, see Run an SSIS package using stored procedure activity in Azure Data Factory.

Next steps

Learn about options for scheduling SSIS packages deployed to Azure. For more info, see Schedule SSIS packages in Azure.