Well, you can't find the inserts without loading the destination table, as the lookup needs something to compare the data to.
If your source and your staging are SQL Server tables (2008 or up), you can try the MERGE statement. They would have the be on the same server to be practical though.
How did you configure the lookup component? Did you use a query?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP