Add existing packages

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Add existing packages - bulk copy?

Add existing packages - bulk copy?

Rate Topic

Display Mode

Topic Options

Author

Message

lmacdonald

Posted Wednesday, February 27, 2013 12:20 PM

Grasshopper

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 24, Visits: 87

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

robert.gerald.taylor

Posted Thursday, February 28, 2013 6:49 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 11:10 AM
Points: 740, Visits: 785

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

opc.three

Posted Thursday, February 28, 2013 11:43 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:44 PM
Points: 6,703, Visits: 11,734

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1425367

lmacdonald

Posted Friday, March 01, 2013 6:59 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 24, Visits: 87

Thanks I'll check out the package )

Post #1425489

« Prev Topic | Next Topic »

Permissions