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

Leave a Reply

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

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 )

w

Connecting to %s