question

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 asked PRADEEPCHEEKATLA-MSFT commented

SSIS Package deploy issue

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-factorysql-server-integration-services
image.png (420.6 KiB)
image.png (119.4 KiB)
image.png (94.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hi @RohitKulkarni-6062,

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://docs.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues#transient-fault-error-messages-40197-40613-and-others

https://docs.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://docs.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




· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello Zoe,

I am trying to connect to SSISDB.But i am facing the same issue. Please can you help me how to create a SSISDB :

How i can connect to SSISDB and it got configured.

106858-image.png

Please advise




Regards
RK

0 Votes 0 ·
image.png (155.0 KiB)

Hi @RohitKulkarni-6062, I'm not familiar with Azure database configure, I helped to add the tag of ADF for more user to help resolve the issue.

Also did some online research for you , you may take carefully reference:

https://cloudexcite.com/azure-sql-the-server-principal-is-not-able-to-access-the-database-under-the-current-security-context/

Also here is the official documentation to deploy SSIS package to ADF.

tutorial-deploy-ssis-packages-azure

0 Votes 0 ·

Hi Zoe,

Thanks for your prompt response.

Even I have gone through the same:https://docs.microsoft.com/en-us/azure/data-factory/tutorial-deploy-ssis-packages-azure

And faced the same SSISDB Issues only.I am still doing a lot of investigation on SSISDB.

I have one question. Is it Mandatory SSISDB is required while doing the migration of the SSIS Package to ADF


Regards
Rk

0 Votes 0 ·

Hello Zoe,

I am not able to see the SSIDB Package. Please refer to the screenshot :
I have not logged in with Admin ID.


107512-image.png




Regards
RK

0 Votes 0 ·
image.png (11.8 KiB)
Show more comments