Deploy SSIS package from onprem to Azure managed instance SSISDB catalog

Question

Hello,
We have provisioned Azure SSIS integration runtime (Lift and shift )in our subscription and integrated it with azure MI as a private endpoint and created SSIDB catalog in Azure MI.
I am able to successfully deploy SSIS Project from on-premise to Azure managed instance manually from SSDT solution ,i have created a ADF pipeline with execute SSIS package task and was able to successfully execute the SSIS dtsx pacakage from Azure MI SSISDB catalog.
Now i wanted to automate the SSIS project deployment process to AZURE MI using powershell (we dont have any CICD pipeline integration ). Could anyone please guide/ recommand any template that you have come across to handle this kind of scenario?
Please let me know if you need any further details.

Answer 1

Hello @SethuRam ,
Thanks for the ask and using Microsoft Q&A platform .
I am just curiuos as to what was deployment mechanism you were using before you went the "List and Shift " route ?
The below arctcke from Microsoft should be helpful
https://learn.microsoft.com/en-us/sql/integration-services/ssis-quickstart-run-powershell?view=sql-server-ver15
Please do let me know how it goes .
Thanks
Himanshu

-------------------------------------------------------------------------------------------------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Hi @SethuRam ,

Here is quick-start demonstrates about how to use a PowerShell script to connect to a database server and deploy an SSIS project to the SSIS Catalog.

You may take a reference: ssis-quickstart-deploy-powershell

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.