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

p1

Step 2: – Right click on Project à Export

p2

Step 3: – Save project file

p3

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

p4

Step 4:- Change extension from .ispac to zip

p5

Step 5: Double click on .zip file and you will able to see dtsx file

p6

One thought 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?

    Like

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Cancel

Connecting to %s