Ssis-948

A single component that combines "Truncate Table," "Bulk Load," and "Constraint Verification" into one atomic operation. This ensures that if the data load fails (a common trigger for version-related errors), the staging environment is automatically rolled back to its previous state. Implementation Checklist

// Example adaptive formula _targetRows = (int)Math.Min( DefaultBufferMaxRows, _targetSizeBytes / avgRowSize);