Deploying SSIS Project in SQL Server Management Studio 18.2

1
votes

i am trying to deploy a SSIS project in SQL server Management Studio 18.2 (SQL server 2019). for that when i was trying to create a catalog (SSISDB) under integration services Catalog. SSMS is asking me to create SSIS IR, and while create SSIS IR, its asking to provide Azure Data Factory Subscription. but i don't have subscription and i don't want too subscribe for Azure Data Factory. do i have to purchase subscription to create SSISDB in Sql Server 2019? or do we have alternate option like we had in previous versions of SSMS? Thanks for your help.

enter image description here

1
sql-serverssissql-server-2019

1 Answers

2
votes

Do i have to purchase subscription to create SSISDB in Sql Server 2019?

No, this is not required for on-premise use. The SSIS IR required if your company wants to host the SSIS catalog and execution environment into the cloud. Or, to be more precise, to ADF.

In your case, after entering the password, just click on OK instead of Create SSIS IR just like shown on a screenshot:

enter image description here