PearlJammer1 (9/2/2013)
You can also connect to the Integration Services Server via SSMS, right click on the package under 'Stored packages/MSDB' to locate your SSIS package. then right-click on it and select 'Export Package...' to save it as a file or even move it to another IS Server.
Ok Just clarify 100% before I do this.
I have connected to ssis from ssms and located the package as you mentioned above. So just to clarify, 'exporting' doesnt remove the package from this location - it is in effect just like copy and paste at a simple level - so the package actually stays on the server and performs as nothing has happened ??
Sorry for the hesitation on this, its just the first time i have done this.....:-)
Not a problem - I don't like the first time I do anything regarding SSIS!
Yes, it will save a copy of the package to your specified location and leave the installed package on the server. You can then edit the saved package/file without any impact on the package stored on the server.