SSIS Package deploy issue

Question

Hello Team,

I am trying to deploy the SSIS package into azure. I have selected the Destination and provided the DB credentials and i am getting error .

why it is coming as SSISDB.

And even the Path Icon is also disabled.

Please advise.

In the below metioned URL :

https://www.sqlshack.com/run-ssis-packages-in-azure-data-factory/

I wanted to know which is path mentioned in the below screenshot :

And where is the Package Location is mentioned in the below screenshot:

Regards
RK

Answer 1

Hi @Rohit Kulkarni ,

From the error message, it seems the issue is related with the permission of the account.

Make sure that the account could access the SSISDB.

https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues#transient-fault-error-messages-40197-40613-and-others

https://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage

Also could you please help check use SSMS to deploy the package to see if it could success.

Here is an official documentation for your reference:

https://learn.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-deploy-run-monitor-tutorial?view=sql-server-ver15

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October