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

DTUTIL Utility to Copy / Delete SSIS Deployed in MSDB to File System Expand / Collapse
Author
Message
Posted Wednesday, March 25, 2009 9:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:43 PM
Points: 14, Visits: 233
Vampire (1/15/2009)
@chileu17

That script is meant for KATMAI ( SQL 2008 ).

Cheers,
Vampire


Yes, I posted the wrong version for SQL 2005- sorry for the confusion.

Here is the SQL 2005 version:

SELECT foldername AS FolderName,
[name] AS PackageName
INTO #PackageNames
FROM msdb.dbo.sysdtspackages90 pkg
JOIN msdb.dbo.sysdtspackagefolders90 fld ON pkg.folderid = fld.folderid
ORDER BY FolderName,
PackageName

SELECT 'dtutil /SQL ' + '"' + CASE WHEN LEN(FolderName) = 0 THEN ''
ELSE FolderName + '\'
END + PackageName + '"' + ' /COPY FILE;"C:\OutputFolder\'
+ CASE WHEN LEN(FolderName) = 0 THEN ''
ELSE FolderName + '\'
END + PackageName + '.dtsx' + '"' + ' /QUIET' --suppresses prompt to delete if an older file with same name exists
FROM #PackageNames

DROP TABLE #PackageNames
-----------------------------------------------

I have added quotes to the folder paths, as you will need these if your paths contain spaces. Also, special thanks to Mike Condon for providing me with this script!

Post #683364
Posted Wednesday, March 25, 2009 9:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:43 PM
Points: 14, Visits: 233
Vampire (1/15/2009)
@chileu17

That script is meant for KATMAI ( SQL 2008 ).

Cheers,
Vampire


Yes, I posted the wrong version for SQL 2005- sorry for the confusion.

Here is the SQL 2005 version:

SELECT foldername AS FolderName,
[name] AS PackageName
INTO #PackageNames
FROM msdb.dbo.sysdtspackages90 pkg
JOIN msdb.dbo.sysdtspackagefolders90 fld ON pkg.folderid = fld.folderid
ORDER BY FolderName,
PackageName

SELECT 'dtutil /SQL ' + '"' + CASE WHEN LEN(FolderName) = 0 THEN ''
ELSE FolderName + '\'
END + PackageName + '"' + ' /COPY FILE;"C:\OutputFolder\'
+ CASE WHEN LEN(FolderName) = 0 THEN ''
ELSE FolderName + '\'
END + PackageName + '.dtsx' + '"' + ' /QUIET' --suppresses prompt to delete if an older file with same name exists
FROM #PackageNames

DROP TABLE #PackageNames
-----------------------------------------------

I have added quotes to the folder paths, as you will need these if your paths contain spaces. Also, special thanks to Mike Condon for providing me with this script!

Post #683368
Posted Wednesday, March 25, 2009 11:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:43 PM
Points: 14, Visits: 233
Admin- my browser was hanging and it looks like this got posted multiple times...
Post #683515
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse