SQL Server DTS

Good Day.

We have a group of folks with limited Oracle experience who are looking to use SQL Server DTS packages to pull data from our Oracle server to populate a SQL Server data warehouse.

I have limited experience with DTS. One concern is the locking behavior that we'd see and all the other crap that comes with SQL Server.

Does anyone use DTS in this way? Wouldn't I be better off replicating the requisite data to a different schema and letting them run their DTS packages against that schema, rather than running directly against production tables?

Thanks,

jeff

--
http://www.freelists.org/webpage/oracle-l