ADO.NET Destination Custom Propertiees?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » ADO.NET Destination Custom Propertiees?

ADO.NET Destination Custom Propertiees?

Rate Topic

Display Mode

Topic Options

Author

Message

seshasai.n

Posted Tuesday, January 08, 2013 2:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 9:52 AM
Points: 2, Visits: 82

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

opc.three

Posted Wednesday, January 09, 2013 10:01 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:53 PM
Points: 6,724, Visits: 11,768

Please post all error messages.

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1404881

« Prev Topic | Next Topic »

Permissions