January 28, 2010 at 9:54 am
Is there an easy way to move dts packages on SQL Server from one folder to another. I have all pkgs in MSDB folder of SSIS and would to move them to a new folder.
January 28, 2010 at 11:36 am
OK, my running the below query it solved my problem.
SELECT p.name, p.folderid, f.foldername
FROM dbo.sysdtspackages90 p JOIN dbo.sysdtspackagefolders90 f
ON p.folderid = f.folderid
An example for moving packages from the MSDB root folder into the Prod folder:
UPDATE dbo.sysdtspackages90
SET folderid =
(SELECT folderid FROM dbo.sysdtspackagefolders90 WHERE foldername = 'Prod')
WHERE folderid =
(SELECT folderid FROM dbo.sysdtspackagefolders90 WHERE parentfolderid IS NULL)
Delete package from an MSDB folder
DELETE FROM dbo.sysdtspackages90
WHERE name = 'PackageName' AND folderid =
(SELECT folderid
FROM dbo.sysdtspackagefolders90 WHERE foldername = 'Foldername')
Using these hints I think it's easy to use these kind of queries 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply