I had an SSIS package that was deployed to the SSIS catalog called package.dtsx. I renamed this package (In SSIS Data Tools by right clicking on the package and selecting rename) to Client1.dtsx and then deployed it to the catalog.
So at this point I had Client1.dtsx AND package.dtsx in the catalog which technically is a duplicate (just different names). So I deleted the package.dtsx by using the below code in SQL: