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


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 )

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 )

Connecting to %s