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
4 thoughts on “How to export SSIS package ( dtsx file) from SSISDB”
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.
Double check where you’re trying to export. The “Export…” option appears when I right click on the Project. It does not appear for an individual Package.
I get this error, any help?:
The package failed to load due to error 0xC0010014 “One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.”. This occurs when CPackage::LoadFromXML fails.
Is there anyway to automate downloading ALL packages from SSISDB for ALL projects? I need to do this so I can add to SubVersion repository for versioning.