Updated on 2024-10-14 GMT+08:00

Deploying an SSIS Project

Scenarios

Run a stored procedure to deploy an SSIS project.

Prerequisites

You have connected to an RDS for SQL Server instance. For details about how to connect to an instance, see Connecting to an Instance.

Procedure

Run the following command to deploy an SSIS project:

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

  • @task_type: task type. Set this parameter to DEPLOY_PROJECT.
  • @folder_name: SSIS folder name.
  • @project_name: SSIS project name.
  • @file_name: name of the .ispac file generated by the SSIS project.

Example

Run the following command to deploy the SSIS project DeploymentTutorial:

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

After the deployment is successful, the following information is displayed:

HW_RDS_Process_Successful