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 ««12

Exporting Multiple SSIS packages from MSDB Expand / Collapse
Author
Message
Posted Wednesday, February 27, 2013 2:43 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:09 PM
Points: 70, Visits: 320
I never written scripts before and I need to copy all these MSDB Packages to a folder on the C: drive. I need something that can populate the SAMPLEPACKAGENAME in the command below with all the packages names from sysssispackages table. Some packages are not in the root of MSDB and would require the folder name to be specified in the quotes so sysssispackages may not be the best table to use since it does not specify the location.

DTUTIL /SQL "SAMPLEPACKAGENAME" /COPY FILE;C:\SSISPACKAGE\SAMPLEPACKAGENAME.DTSX /QUIET
Post #1424759
Posted Friday, March 1, 2013 9:48 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:17 AM
Points: 21,213, Visits: 14,911
Here is an article I wrote on the topic to export the packages.

http://jasonbrimhall.info/2010/12/28/ssis-multiple-file-export/




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1425596
Posted Wednesday, May 8, 2013 4:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 2:17 AM
Points: 101, Visits: 197
Hi,

I'm sorry if I missed the solution here but I need to export SEVERAL projects (folders) with tens of SSIS packages from Sql Server 2008 MSDB to Sql Server 2012 MSDB.

Any smooth way to do this?

Ville
Post #1450494
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse