Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

ADO.NET Destination Custom Propertiees? Expand / Collapse
Posted Tuesday, January 8, 2013 2:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 3:58 AM
Points: 4, Visits: 93
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 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.

Post #1404083
Posted Wednesday, January 9, 2013 10:01 AM



Group: General Forum Members
Last Login: Friday, December 2, 2016 3:25 AM
Points: 7,933, Visits: 14,355
Please post all error messages.

There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1404881
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse