How to deploy packages in SSMS 18.1 or 17.X

In 2017, during package deployment SSMS gets closed on its own saying "SSMS stopped working" after upgrading packages from SQL Server 2008 to SQL Server 2017 in Windows 2016 Standard operating system.

One way is to overcome this to have latest data tools 15.9.1 and go with Integration Services catalog in Integration services catalog. For this, it requires multiple changes in pacakages. For example changing the folder location instead of file system or MSDB..etc.

The other way is to go with DTUTIL. It works as same as legacy deployments model as SSMS. Only difference is you need to use command prompt or power shell.

If you want to deploy in MSDB:

C:\Program Files\Microsoft SQL Server\140\DTS\Binn>DTUTIL / DestS <<Servername>>/file "Location of the package in local machine" /Copy "SQL;package name"

If you want to deploy folder out side MSDB:

C:\Program Files\Microsoft SQL Server\140\DTS\Binn>DTUTIL / DestS <<Servername>>/file "Location of the package in local machine" /Copy "SQL;\folder name \package name"

If the package already exists it will ask whether to override or not. You can choose yes\no.

This is one of the issue that i come across with recent upgrade. I hope it will be useful.