InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 15:59:42 GMT20http://www.sqlservercentral.com/Forums/Topic1404083-148-1.aspxPlease post all error messages.Wed, 09 Jan 2013 10:01:37 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1404083-148-1.aspxHi 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.Tue, 08 Jan 2013 02:55:59 GMTseshasai.n