SSIS

• pmaceke

  Ten Centuries

  Points: 1018

  More actions

  January 24, 2017 at 7:53 am

  #318164

  Hi,

  I've package that reads data from iSeries database. I'm using ODBC connection to pull multiple tables from iSeries database to our SQL Server 2012 database.
  All my tables load very fast except one table which loads very slow. When this particular table starts loading, it reads at the same pace as others tables when you look at the data flow but along the process it deteriorate the speed to the point where it takes more than 2 minutes to see the records changing on the data flow.

  Please advise what could the cause. My ODBC source has been set to FetchMethod Row by Row
  My OLE DB destination has been set as follows:
  Data access mode: Table or view - fast load
  Rows per batch : 10000
  Maximum insert commit size:100000
  Table lock and Check constraints not ticked.

  I also tried using Balance Data Distributor but it does not help. Your help in this regard will be highly appreciate.

• Thom A

  SSC Guru

  Points: 99133

  More actions

  January 24, 2017 at 8:00 am

  #1924632

  Duplicate of topic https://www.sqlservercentral.com/Forums/1853363/SSIS-package-running-very-slow. Please only create one topic per problem.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk