MSBI (SSIS/SSRS/SSAS) Online Training

Friday, February 13, 2009

Unit Testing in SSIS

Hi ,in SSIS Unit testing is important and it’s basically testinf from Developer end.
Am posting a brief introduction about the Unit testing.
ssisUnit is a unit testing framework for SQL Server Integration Services. ssisUnit is a unit testing framework for SQL Server Integration Services. It is loosely based on the xUnit family of unit testing frameworks, but is tailored to better support the SSIS environment. One of the bigger differences is that you do not have to write code to create the unit tests. Instead, we have taken a declarative approach to specifying the unit tests. The test information is all stored in XML files. Since many SSIS developers do not have a background in coding traditional applications, we felt it was important to deliver something that did not require an understanding of .NET development to use.ssisUnit supports task level testing in SSIS. Any control flow task can have a set of tests created around it. This level of granularity in testing can make testing complex packages much easier.

See For More Details:
http://stevemchugh.blogspot.com/2007/05/unit-testing-ssis.html

Unit Test Structure

No comments: