Load data from Oracle error

• sarran.achari

  SSCrazy

  Points: 2226

  More actions

  June 16, 2011 at 11:53 am

  #238179

  Gurus,

  We have created a simple SSIS package to load around 50 lakh records from Oracle to SQL Server using Attunity 1.0. It fails after 16000 records at the source saying error DTS_Primeoutput failed with out mentioning on any other information... Earlier when we tried using OLE DB provider it used to load around 14K records and fail... When we changed the MaxInsertcommitsize property along with Buffer rows to 1000 the number of records that it loads varies from 12K to 16K...

  We are unable to solve this issue... Any help would be very much appreciated...

• Jorge Segarra

  SSCrazy

  Points: 2571

  More actions

  June 16, 2011 at 12:20 pm

  #1339961

  Is it possibly bad records coming from the source? Can you split off invalid records to an error output? (see picture)

  

  =============================================================
  /* Backups are worthless, Restores are priceless */

  Get your learn on at SQL University!
  Follow me on Twitter | Connect on LinkedIn
  My blog: http://sqlchicken.com
  My book: Pro Server 2008 Policy-Based Management