Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

June

13

WISSUG June 2017 meeting

  • In-Person @ 833 E Michigan St Milwaukee, Wisconsin, United States (map)
  • 16:30 - 18:00 Central Daylight Time
  • Language: English

Testing SSIS Packages

Presented by

Tim Mitchell (Tyleris Data Solutions)

Note: The June meeting will be our first at Microsoft's new downtown office at 833 E Michigan St.

Senior developer: "How do you test your code?"

Junior developer: "I compile it."

 

It’s an old joke, but too often this reflects the reality of testing.

If the code compiles, it has passed its test.

 

Sadly, this principle is sometimes applied to Extract-Transform-Load (ETL) processes as well: "When the SSIS package runs without error, testing is complete."

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

 

 

PASS Summit 2017 - Seattle, WA   30 Oct - 03 Nov

Registration discount code: LC15HFK3  (save $150!)

PASS Summit site: PASS Summit 2017