SSIS如何使用一个服务器中的表中的查询来选择另一个服务器中的数据

I have two unlinked servers one production and one reporting. I'm using an SSIS package to incrementally update a table on the reporting server. On the reporting server I have a staging table that lists items that need to be updated or imported. Currently I have a data flow task that pulls the source table from the source server, does a look up with the staging table and then updates the destination table. My problem with this is I don't want to have to pull the entire source table everytime I run the update. Is there a way to use the staging table from reporting server to select data from the the production server? Basically I want my data source query to look something like this. I have two unlinked servers one production and