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

Applies to: yesSQL Server (all supported versions) yes 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.

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 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 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.