Link to home
Start Free TrialLog in
Avatar of dsoderstrom
dsoderstrom

asked on

Reviewing a saved SQL Server Integraton Services package

How to you go back and look at the details of an Integration Services package that has been saved?
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Open Visual Studio, File menu, Open..., File, and find your .dtsx file out on the file system, and Open.
in SSIS undo is not working for all the changes..

Thanks,
Nishant
If you have them in the file system folder in the SSIS, you can also export the package from the server, save it in the File System, you can then create a new SSIS project and import it.

This could help when you don't have the original package files.
Avatar of dsoderstrom
dsoderstrom

ASKER

I created a new export package using the SQL server Import Export Wizard.
I checked the box that said "Save SSIS Package" and gave it a name when prompted.
After doing that, I can see it when I go into SQL Server Management Studio, Open Integration services and look under Stored Packages\MSDB.  It does not show up under "Stored Packages\File System".  Also, if I use Windows Explorer Search and look for "*.dtsx" it does not show up anywhere.  Do I have to right click on the package under Stored Packages\MSDB and do the "Export Package" option in order to create the "dtsx" file?
ASKER CERTIFIED SOLUTION
Avatar of Member_2_861731
Member_2_861731
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That was very helpful.  Thanks.