System is low on Virtual Memory

• piklu

  SSC Enthusiast

  Points: 105

  More actions

  September 23, 2008 at 2:48 am

  #127547

  While executing a SSIS package I am facing an error message saying:

  "The buffer manager detected that the system is low on virtual memory...." and followed by

  " [DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled."

  This package is simply loading the data from an oracle database to Sql server database. The volume of data is around 60 milion. I am using OLE DB destination with fast load option. Can anyone suggest if I can make any configuration change in any of my task to make it work?

• Prachi-885067

  SSC Veteran

  Points: 208

  More actions

  September 23, 2008 at 6:44 am

  #875598

  Check for memory settings used in SSIS data flow. For more details check http://msdn.microsoft.com/en-us/library/ms141031.aspx