You might be able to get away with the following:

INSERT INTO HFM_Auxiliar.dbo.HFM_Applications (Appname)

SELECT DISTINCT Appname

FROM hfm.dbo.HSX_DATASOURCES

EXCEPT

SELECT DISTINCT Appname

FROM HFM_Auxiliar.dbo.HFM_Applications