If, for reasons of scaling and performance, you think that your DW database will, or may, reside on a different SQL instance from your OLTP database, you should also consider running the ETL using a tool such as SSIS. This allows you to decouple your databases (so that database A contains no references/dependencies to database B).