February 27, 2013 at 12:20 pm
Hi,
We are shutting down a server and I want to get a copy of the packages in the MSDB before it's retired. In Visual Studio I've been told to right click on packages folder and select add existing package. I put in the server and then browse for the package and this works. However there are many and I can only select one at a time. I may have to do this on other servers in the near future. Does anyone know a bulk way of doing this?
February 28, 2013 at 6:49 am
Reading this thread: http://www.sqlservercentral.com/Forums/Topic836951-146-1.aspx,
the packages are stored in the [font="Courier New"]sysdtspackages90[/font] in the msdb database. You can take the xml and store it in a .dtsx file and have the original package. I've never done it this way, but it sounds like what you're after.
HTH,
Rob
February 28, 2013 at 11:43 pm
Just for clarity, msdb.dbo.sysdtspackages90 is where Pakages were stored in SQL Server 2005. In SQL Server 2008 they are stored in msdb.dbo.sysssispackages.
Here is a PowerShell script already written that needs only a minor tweak or two to wrk for you in your environment to get files from the Packages in the server:
Export all SSIS packages from msdb using Powershell
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 6:59 am
Thanks I'll check out the package )
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply