Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Add existing packages - bulk copy? Expand / Collapse
Author
Message
Posted Wednesday, February 27, 2013 12:20 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 12:14 PM
Points: 72, Visits: 334
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?
Post #1424682
Posted Thursday, February 28, 2013 6:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:28 AM
Points: 1,197, Visits: 1,241
Reading this thread: http://www.sqlservercentral.com/Forums/Topic836951-146-1.aspx,

the packages are stored in the sysdtspackages90 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
Post #1425029
Posted Thursday, February 28, 2013 11:43 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:47 AM
Points: 7,126, Visits: 12,727
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
Post #1425367
Posted Friday, March 1, 2013 6:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 12:14 PM
Points: 72, Visits: 334
Thanks I'll check out the package )
Post #1425489
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse