I had to add the following stored procedure to be able to save in SSIS package

CREATE PROCEDURE [dbo].[sp_dts_getfolder]

@name sysname,

@parentfolderid uniqueidentifier

AS

SELECT

folder.folderid,

...