How to export SSIS package ( dtsx file) from SSISDB

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

  1. 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?


    1. 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.


  2. 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.


  3. 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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s