tags:

views:

36

answers:

1
Q: 

How to test the SSIS Packages?

Hi,

 How to test the SSIS Packages ? what are the things should be taken care while testing

the ssis packages? what are the testcase steps should be written while testing ?

regards, kumar

A: 

ssisUnit is a great tool for unit testing an SSIS package. The only caveat I have run into is that you need to run the unit tests on a machine with SSIS server components installed. I work in a shop where I have the SSIS client components installed, but the server is remote (I have Sql Server Express on my local box) so I am currently unable to use ssisUnit in my development. This means I have to write my scripts manually which is a much bigger pain.

William Todd Salzman  2010-05-10 14:14:08

related questions

Unit tests for deep cloning
What is the difference between integration and unit tests?
Unit test execution speed (how many tests per second?)
Run PHPUnit Tests in Certain Order
Testing a function that throws on failure
What do you use to Unit-Test your Web UI?
How do you test/change untested and untestable code?
How to make junior programmers write tests?
How do you mock a Sealed class?
RhinoMocks: How do you properly mock an IEnumerable<T>?
What is the best way to do unit testing for ASP.NET 2.0 web pages?
TDD and Mocking Frameworks
Unit testing with VSTest basics
How to set up unit testing for Visual Studio C++
What are the primary differences between TDD and BDD?
What is Your Experience with Unit Testing in Practice?
How can I unit test Flex applications from within the IDE or a build script?
C# Unit Testing Example
How do I unit test persistence?
.NET Unit Testing packages?
Integrating Visual Studio Test Project with Cruise Control
What is unit testing?
Best way to implement unit testing in PHP
.NET Testing Framework Advice
Using combinations of sets as test data