Have you consider log shipping from source sql server to your datawarehouse server and then querying the database locally on your datawarehouse server?

chrno