SSIS Package deploy issue

Rohit Kulkarni 691 Reputation points
2021-06-17T16:27:31.41+00:00

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.

106688-image.png

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 :

106689-image.png

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

106637-image.png

Regards
RK

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,799 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,587 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 37,221 Reputation points
    2021-06-18T02:27:00.48+00:00

    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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.