SSIS performance tuning Default Buffer Max Rows

  • Just a quick question.

    when you set the default buffer max rows - should this value be based on

    a) the record size from the source - or

    b) the maximum records size that exists in the dataflow pre-destination table? (i.e. do i need to accomodate for the derived columns etc in the buffer size)

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • I believe number 2.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • thanks.

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply