Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ADO.NET Destination Custom Propertiees? Expand / Collapse
Author
Message
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: Friday, August 22, 2014 1:07 AM
Points: 4, Visits: 92
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.
Post #1404083
Posted Wednesday, January 9, 2013 10:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 7,098, Visits: 12,606
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