I get columns labeled folderid, foldername, parentfolderid, and foldername
with no data returned. What does that mean? >>> just means there is not folder - eventhough you can visually see it
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_dts_addfolder'.
What does that mean? >>>> It just means I was running the command on the wrong DATAbase when I ran the it must be ran against the MSDB database;;;;; therefore ((I'm not sure about Brad2575's line there, but it seems to bee on the right direction -- points for brad thanks for all
I did not try your solution but it seems to be pointing to right direction the msdb database
BAOTech
try running this
INSERT INTO dbo.sysdtspackagefolders90 (
folderid
,parentfolderid
,foldername)
VALUES (
NEWID() -- New GUID for our new folder
,'00000000-0000-0000-0000-000000000000' -- Lookup the parent folder GUID if a child or another folder, or use the root GUID 00000000-0000-0000-0000-000000000000
,'Maintenance Plans' ) -- New folder name