Avatar of pireseder
pireseder
Flag for United States of America asked on

How would I fix the Could not find store procedure 'sp_dts_addfolder' error

When I execute
exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfolder] @P1, @P2',N'@P1
nvarchar(17),@P2 uniqueidentifier',N'Maintenance
Plans','00000000-0000-0000-0000-000000000000'

I get columns labeled folderid, foldername, parentfolderid, and foldername
with no data returned.  What does that mean?

When I execute

exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance
Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

I get the following error message:

Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_dts_addfolder'.

What does that mean?
exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance 
Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

Open in new window

Microsoft SQL Server 2005MySQL Server

Avatar of undefined
Last Comment
BAOTech

8/22/2022 - Mon
brad2575

it means there is not a stored procedure called "sp_dts_addfolder"
pireseder

ASKER
How do I  make sure all my store procedures are there, is this part of a bad installation?
ASKER CERTIFIED SOLUTION
brad2575

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
pireseder

ASKER
exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfolder] @P1, @P2',N'@P1
nvarchar(17),@P2 uniqueidentifier',N'Maintenance
Plans','00000000-0000-0000-0000-000000000000'

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

==============
When I execute

exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance
Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

I get the following error message:

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

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
pireseder

ASKER
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