Good work! You sure have a good product. I work for Avanade and have shared this amongst the communities, expect a lot of Avanade SSIS architects to pick this up for evaluation. I have been trying this out in my project and have created some documentation
to get my team trained on the tool. I am happy to share or if you would like build the documentation for the product.
A couple of questions
- The test files created through SSISUnit are of the type ‘myTestName.SSISUnit’, can I call the tests to be executed through Visual Studio08?
Example in Visual Studio MyTestProject.csproj I would like to make a call for the execution of myTestName.SSISUnit, this is how I used to do it for tests created in BizUnit
public void Test_01_FILECopyWithXmlValidation()
BizUnit.BizUnit bizUnit =
new BizUnit.BizUnit(@"F:\tarun.arora\Visual Studio 2005\Projects\TestSSISUTs\MyTestProject\XMLFile1.xml");
Can you share how you have implemented this?
2. Statistics, The code coverage? Is there a way to find out the tasks covered and the times they were called?
I am pretty new to SSIS and its unit testing. I created a sample SSIS package and tried both BizUnit 3.1 and SSISUnit 1.0,
Personally I found SSISUnit easy to steer while writing the test cases, the areas where it scores over BizUnit
1. Option to create a test using a package - This automatically picks up the useful information of database connection string, possible test cases in terms of the package tasks.
2. Level of Testing - SSISUnit not only allows end to end testing of the package but also lets one dig deep and test at the task level. It does this by identifying the GUIDs associated with the package
Tasks and gives user the option of running tests at the task level. This is a major plus because it will allow writing unit test at a more granular level.
I would like your take on this – I think it would be possible to test this with BizUnit too. I can write a test using BizUnit with which I can query the tables modified by that task and asset the same with
the help of some sql queries. But this approach would fail if the package during its execution re-modifies the same table.
So, consider an example, Table Calc has columns number 1 and number 2
- The first task in the package inserts 5 in the column number1 and 7 in the column number2
- The second task in the package updates the row with 15 in the column number1 and 27 in the column number2
Can I use SSISUnit to test the first task operation and then further do an end to end test to check the entire flow?
Graphical user interface - I cannot contest too hard on this, though BizUnit 3.1 also has this feature, yet I felt that the GUI in SSISUnit is more relevant to SSIS testing and helps reduce the possibility of introducing casual errors
in the unit tests.
SSISunit is still fresh in the market, it's still at version 1. There are not many samples or help docs available. While BizUnit has reached version 3.1 and has strong community support and help