Hi gurus,

I am doing a migrition from SQL Server to Oracle using DTS on a Win2K box. I noticed that DTS is consuming too much virtual memory which make the migration fail because of out of memory.

According to the task manager, the VM consumed by DTS is about 1.8GB while the memory is only 245MB. Anybody know why? How can I restrict the VM usage of DTS?

FYI -- I am using

SQL Server 2K
Oracle 9.0.1
Server config: win2K, dual processor P-III 933MHz, 1GB RAM

Thanks a lot,
Elaine

MS Sql Server LazyDBA home page