Issue – How to export .dtsx file from SSISDB as from SQL 2012 onward you will not see .dtsx package listed in integration services.
Note – This is shortcut solution.
Step 1: – Go to Integration Services Catalogs à Project
Step 2: – Right click on Project à Export
Step 3: – Save project file
Note – ensure File Name extension is enabled.
If it’s not enabled; you can enable it by going to view on file explorer and check File name extensions
Step 4:- Change extension from .ispac to zip
Step 5: Double click on .zip file and you will able to see dtsx file