Managing and Running the Project in SSMS
By default, connection settings with sensitive information (passwords, security tokens, etc.) are redacted when deploying to Azure. To be able to execute projects in the configured Azure Data Factory, provide this information through SSMS.
1. Connect to the Azure SQL database. In Options -> Connection Properties, set the Connect to Database field to "SSISDB".
2. Right-click the project and click Configure to configure the SSIS project in the Integration Services Catalog.
Note: If you do not see Integration Services Catalogs, you may need to upgrade your SSMS version or set "SSISDB" in step 1.
3. Add connection information as necessary in the Connection Manager tab. Provide the RTK connection property.
You can then execute the project. View the results of execution by right-clicking the project and clicking Reports -> All Executions.