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
We have a SQL 2017 Enterprise . Project deployment mode. I and another team members are in SSIS Admin role on SSISDB .
For some reason “Export…” option is missing on drop down list. We have extra option “Execute in scale out… ” grayed out , but Export is missing competently.
Any idea?
LikeLike