Monthly Archives: September 2013

SSIS Tuning–Packet Size

Tuning the packet size property in connection managers can often yield significant performance improvement.  By default the packet size is 0 for OLE DB connections which defaults to the instance packet size.  In most cases the default value is 4096.  … Continue reading

Posted in Performance, SQL Server Integration Services | Leave a comment