InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 08:40:08 GMT20http://www.sqlservercentral.com/Forums/Topic1424682-1292-1.aspxThanks I'll check out the package )Fri, 01 Mar 2013 06:59:23 GMTlmacdonaldhttp://www.sqlservercentral.com/Forums/Topic1424682-1292-1.aspxJust 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:[u][url=http://sqlblog.com/blogs/jamie_thomson/archive/2011/02/02/export-all-ssis-packages-from-msdb-using-powershell.aspx]Export all SSIS packages from msdb using Powershell[/url][/u]Thu, 28 Feb 2013 23:43:29 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1424682-1292-1.aspxReading this thread: [url]http://www.sqlservercentral.com/Forums/Topic836951-146-1.aspx[/url],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,RobThu, 28 Feb 2013 06:49:14 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1424682-1292-1.aspxHi,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?Wed, 27 Feb 2013 12:20:29 GMTlmacdonald