Loading Data into Oracle Server from Access DB using SSIS :- Performance Issue

• ashloveu27

  Grasshopper

  Points: 18

  More actions

  January 27, 2009 at 1:59 am

  #199290

  I have approx. 1 million rows in my source table and it loads 0.2 million and gives low buffer memory error.

  Anybody knows the methods for improving performance in SSIS for Data migration to Oracle as destination.

  I have already tried altering the Data Flow variables like defaultBufferSize etc... But No effect...

  Help me....:ermm:

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9149

  More actions

  February 4, 2009 at 10:03 am

  #938152

  Hi

  Are you getting this "low buffer memory error" on Oracle side?

  Thanks -- Vj

  http://dotnetvj.blogspot.com

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers

  
  

• ashloveu27

  Grasshopper

  Points: 18

  More actions

  February 4, 2009 at 7:46 pm

  #938567

  no.

  It is on SSIS side.

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9149

  More actions

  February 5, 2009 at 11:26 am

  #939074

  Hi

  What is AVG size of the record?

  What is the DefaultBufferSize set to?

  What is the DefaultMaxBufferRows set to?

  Mean while check out the below articles to modify the above attributes in order to increase the speed of the data load.

  http://www.sqljunkies.com/WebLog/ashvinis/archive/2005/04/06/10467.aspx

  Thanks -- Vj

  http://dotnetvj.blogspot.com

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers