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
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.
LikeLike
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.
(SNBW_VP_TFN_Lookup_from_Prod)
LikeLike