ADO.NET Destination Custom Propertiees?

• seshasai.n

  SSC Rookie

  Points: 32

  More actions

  January 8, 2013 at 2:55 am

  #393893

  Hi I tried to loading xml into Oracle table using SSIS,

  OLEDB destination wont support, so I use ADO.Net Destination,

  ADO.NET Destination will load upto some records and then its failing so,I increase the Batch size property of the ADO.net Destination property.

  I need One clarification, how to calculate the Correct Batch size, If it is internal buffer size, then how to calculate the Internal Buffer size, and How it relates to batchsize.

  thanks,

  Sai.

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  January 9, 2013 at 10:01 am

  #1575334

  Please post all error messages.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato