« Existence Check Deconstructed -- SSIS Lookup Transformation | Main | SSWUG Expo..I'm up! »

PrintView Printer Friendly Version

EmailEmail Article to Friend

References (1)

References allow you to track sources for this article, as well as articles that were written in response to this article.

Reader Comments (3)

Thanks for this--very helpful. How do you recommend finding the average size of the source record? I have tried using the metdata from the data flow, but the BufferSizeTuning logging event always proves me wrong...

Any guidance on this?

April 29, 2012 | Unregistered CommenterDSP

You can do the "lazy man's way" and simply look at the number of records in the table and divide it by the total size or add up all the fixed size columns and then take each variable size column/2 and add them up.

April 29, 2012 | Registered CommenterJosef Richberg

SSIS uses the maximum size of variable length columns (regardless of how much of that space is redundant) when estimating row size. Say you have a varchar(50) which only has strings of 4 characters, SSIS will allocate 50 bytes, not 4, and certainly not 2!

May 25, 2012 | Unregistered CommenterAndyD

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>