Deploying an SSIS Project

Run a stored procedure to deploy an SSIS project.

You have connected to an RDS for SQL Server instance.

Run the following command to deploy an SSIS project:

EXEC msdb.dbo.rds_ssis_task '@task_type', '@folder_name', '@project_name', '@file_name';

Run the following command to deploy the SSIS project DeploymentTutorial:

EXEC msdb.dbo.rds_ssis_task 'DEPLOY_PROJECT', 'test_ssis', 'DeploymentTutorial', 'DeploymentTutorial.ispac';