Welcome to the Wisconsin SQL Server Users Group

Next Meeting




WISSUG August 2016 chapter meeting

  • In-Person @ N19W24133 Riverwood Drive, suite 150 Waukesha, Wisconsin, United States (map)
  • 16:30 - 18:00 Central Daylight Time
  • Language: English

Testing SSIS Packages

presented by

Tim Mitchell

Featured Presentation:

Testing SSIS Packages

Tim Mitchell, Principal Data Architect Tyleris Data Solutions

As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system. This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these: * Performance testing * Patterns for validating execution results at runtime * Validating package metadata before execution * Design time versus runtime testing * Making a graceful exit: testing for error handling

About Tim:
Tim Mitchell is a business intelligence consultant, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQL Saturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.