For more info about deploying and running packages in Azure, see Lift and shift SQL Server Integration Services workloads to the cloud. You can use the information in this quickstart to run an SSIS package on the following platforms:Īzure SQL Database. If you're trying to connect to an Azure SQL Database server from within a corporate firewall, this port must be open in the corporate firewall for you to connect successfully. To download SSMS, see Download SQL Server Management Studio (SSMS).Īn Azure SQL Database server listens on port 1433.

Prerequisitesīefore you start, make sure you have the latest version of SQL Server Management Studio (SSMS). For more info about SSMS, see SQL Server Management Studio (SSMS). SQL Server Management Studio is an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database.

This quickstart demonstrates how to use SQL Server Management Studio (SSMS) to connect to the SSIS Catalog database, and then run an SSIS package stored in the SSIS Catalog from Object Explorer in SSMS.

SSIS Integration Runtime in Azure Data Factory