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,

folder.foldername,

folder.parentfolderid,

parent.foldername

FROM

sysssispackagefolders folder

LEFT OUTER JOIN

sysssispackagefolders parent

ON

folder.parentfolderid = parent.folderid

WHERE

folder.foldername = @name AND

(folder.parentfolderid = @parentfolderid OR

(@parentfolderid IS NULL AND folder.parentfolderid IS NULL))