如何使用T-SQL在MSDB中为SSIS包创建一个文件夹?

Question

解决方案

你可以使用T-SQL语句直接在msdb数据库的用户表dbo.sysssispackagefolders中直接插入一条记录，如下:
INSERT INTO dbo. sysssispackagefolders (
folderid
,parentfolderid
,foldername)
VALUES (NEWID(), '<Parent folder GUID>', '<Folder name>')
For example, if you want to create a folder named “Packages” under the MSDB folder, you can run the following T-SQL:
INSERT INTO dbo. sysssispackagefolders (
folderid
,parentfolderid
,foldername)
VALUES (NEWID(), '00000000-0000-0000-0000-000000000000','Packages')

Answer 1

楼上的解说很明白了，直接向MSDB数据库的dbo. sysssispackagefolders表中添加记录即可。