SQL Server Performance Tuning and Optimization

SQH05 Would You Just Load Already?! Maximizing Your SSIS Data Load


9:30am - 10:45am

Level: Intermediate

Chris Bell

Data Platform MVP

Consultant and Speaker

WaterOx Consulting, Inc

Loading data via SSIS is great. It's also fast, at least until you hit a bad record. Then things aren't so great. Now you probably have to waste time dumping and reloading all the data, or worst figure out where the bad record is and try a partial load. This session will show you a simple method to load data via SSIS and identify, remove, and record those bad records, allowing you to maximize the amount of data loaded while ensuring data integrity.

You will learn:

  • How to filter bad data from your data loads
  • How to maximize the speed of your load, even with bad data
  • How to ensure maximum data loaded while maintaining its integrity