right, though this would ideally be present on the source server. pushing IDs from destination to source direct in the DB will be robust enough to get over my major problem. I'll just define the select queries in the DB of the source server (not perfect, but good enough for now), and write my ETL to target those remote queries. thanks.