I am having 80 millions record in a table. I want to move all the
records to a destination table using SSIS. I am using OLEDB Source and
OLEDB Destination in Dataflow Tasks for moving the records.

I want to move 10000 records per batch. I have updated 10000 in the
OLEDB Destination Editor-->Connection Manager-->
Rows per Batch = 10000. The Default value was 1.

My Question is :

1)Does this update, really boost up my performance of the
transformation?
2) What is the maximum value i can give which does not affect my
performance.
3) Do we have any other Data Flow Task which transfers the data quickly
between tables in SSIS.

*** Sent via Developersdex http://www.developersdex.com ***

Take a look at the DefaultBufferMaxRows property for the Data Flow task in
question. (3rd in the list under Misc.) The default is 10,000. Since the data
flow 'pipeline' happens in-memory, you will be somewhat restricted by
available memory on the machine.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Ahamed Faridh" wrote:

Take a look at the DefaultBufferMaxRows property for the Data Flow task in
question. (3rd in the list under Misc.) The default is 10,000. Since the data
flow 'pipeline' happens in-memory, you will be somewhat restricted by
available memory on the machine.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Ahamed Faridh" wrote:

Take a look at the DefaultBufferMaxRows property for the Data Flow task in
question. (3rd in the list under Misc.) The default is 10,000. Since the data
flow 'pipeline' happens in-memory, you will be somewhat restricted by
available memory on the machine.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Ahamed Faridh" wrote:

Take a look at the DefaultBufferMaxRows property for the Data Flow task in
question. (3rd in the list under Misc.) The default is 10,000. Since the data
flow 'pipeline' happens in-memory, you will be somewhat restricted by
available memory on the machine.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Ahamed Faridh" wrote:

Take a look at the DefaultBufferMaxRows property for the Data Flow task in
question. (3rd in the list under Misc.) The default is 10,000. Since the data
flow 'pipeline' happens in-memory, you will be somewhat restricted by
available memory on the machine.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Ahamed Faridh" wrote:

Take a look at the DefaultBufferMaxRows property for the Data Flow task in
question. (3rd in the list under Misc.) The default is 10,000. Since the data
flow 'pipeline' happens in-memory, you will be somewhat restricted by
available memory on the machine.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Ahamed Faridh" wrote:

Take a look at the DefaultBufferMaxRows property for the Data Flow task in
question. (3rd in the list under Misc.) The default is 10,000. Since the data
flow 'pipeline' happens in-memory, you will be somewhat restricted by
available memory on the machine.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Ahamed Faridh" wrote:

Take a look at the DefaultBufferMaxRows property for the Data Flow task in
question. (3rd in the list under Misc.) The default is 10,000. Since the data
flow 'pipeline' happens in-memory, you will be somewhat restricted by
available memory on the machine.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Ahamed Faridh" wrote: