Ssis-948 Review

SELECT TOP 10 * FROM dbo.StagingOrders WHERE LoadDate = CAST(GETDATE() AS DATE) AND OrderDate IS NULL;

When , you can also set TargetRowsPerBuffer and TargetBufferSizeKB directly; the engine will still adjust them within the min/max bounds. ssis-948