« Virtual Presentation: SSIS WorkLoad Thread Balancing. | Main | Simple Series: SSIS Import Column »

PrintView Printer Friendly Version

EmailEmail Article to Friend

References (4)

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

Reader Comments (2)

Is this tested in SSIS 2005 or 2008?

Given execution tree changing and parallel executions, I'm imaging this really being beneficial in SSIS 2008. Would you agree with that assessment Josef? In that, tablock may actually be set for minimal logging and retain the speed?

Thanks for the good article. Always nice to read your blog first thing in the morning :-)

January 7, 2010 | Unregistered CommenterTed Krueger (onpnt)

The example I posted was taken from a package written in SSIS 2005. It seems that fast load in 2008 has tablock,check constraint, and rowsize=1000 by default. I don't know if there is a benefit to tablock if I have a rowsize of 1000, but I will look to test it out.

I'm glad you find my blog informative, that's what I strive for :)

January 7, 2010 | Registered CommenterJosef Richberg

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>