Select SP.name, SP.folderid, SPF.parentfolderid, SPF.foldername
From dbo.sysssispackages SP
Left Join dbo.sysssispackagefolders SPF On SP.folderid = SPF.folderid
Scripts, Articles, Relevant for DBAs, Consultants, BI, Data Scientists and Developers