Data Flow Buffer Size
I started answering a question on SQL Community Slack’s #ssis channel and I realized this would be better served as a blog post. The question was about three SSIS Data Flow properties: DefaultBufferSize, Engine Thread and DefaultBufferMaxRows. I rarely change the EngineThreads property. DefaultBufferSize and DefaultBufferMaxRows are two ways of managing the size limits of a Data …
Continue reading Data Flow Buffer Size