[tp widget="default/tpw_default.php"]

how to write test cases for ssis packages

how to write test cases for ssis packages

how to write test cases for ssis packages插图

Should you automate the testing of your SSIS packages?

Automating the testing of your SSIS packages can save you a lot of time. What’s more important, automated testing is more reliable because it’s done continuously and you can cover more packages. Once you have written tests, you can always run them during automated build processes. In the end, this means fewer errors and better quality.

What is an SSIS packages project?

SSIS stands for SQL Server Integration Services and generally refers to SSIS Packages. An Integration Services Project (IS) is a type of project that allows you to create SSIS Packages.

Can the asserts in ssisunit use expressions?

The unit tests are linked to packages through Package Reference objects, which basically refer to a package by it’s file path, or location in SQL Server. “Can you use a different operator then equal to? Like greater than, less than, different than?” Yes, the Asserts in ssisUnit can use expressions.

How do I integrate ssisunit into a SSIs build?

The simplest way to to incorporate ssisUnit into your builds is by calling the command line test execution tool. It’s called ssisUnitTestRunner2008.exe (substitute the appropriate version number for your version of SSIS) and you can find it in the folder where you installed ssisUnit.

What are Test Cases?

A test case is a test scenario to test functionality with a different set of input and parameters. We test the expected Result of the test case with the expected one. The test case is marked as passed if the output matches and is marked as failed if the output of expected and doesn’t match. Test cases can be executed manually or via automation.

Types of Test Cases

There are different test cases based on the testing methodologies you are following in your project. Some are Functional, API, Performance, Security, Usability, UI, Database, and Unit Test Cases. Functional Test Cases are the ones that are written to test every functionality of the application against user requirements defined by stakeholders.

How to Write Test Cases in an Excel Sheet

For writing test cases in excel you need to make an excel sheet. There is no specific template for writing test cases that have 10 different columns – Test Case ID, Test Case Description, Assumptions, Test Data. Pre-Condition, Test Steps, Expected Result, Actual Result, Status, and Comments.

Test Cases Example

Let’s take an example to write a Test cases example for a web application. They will be around Login, logout functionality test cases, and other functionality-related test cases. UI and performance-related test cases will also be part of test cases.

How to write effective Test Cases

Now, we have looked at the way test cases are written and how to optimize them. This mystery is still not solved yet. Let’s now dig into detail to write effective test cases.


Now, you must be clear on how to write effective test cases. Start downloading our sample test case document and continue with test case designing. It takes time to be an expert in writing test cases, but in no time, you will be an expert by following the above tips.

Which is more accurate, GUID or name?

Each test case can reference tasks by name or GUID . GUID is more accurate, as names can conflict if you have multiple tasks with the same name in different containers.

Can you use SQL command to retrieve specific rows?

Well, I’d use ssisUnit, but I’m not exactly unbiased . Currently, you can do this using the SQL Command, which enables you to retrieve specific row details from the database. In the future, you will be able to do this more directly by testing it in the data flow.

Does Codeplex work against 2012?

It does work against 2008 and 2012. You can download the 2008 version directly from the CodePlex site. For 2012, you need to download and compile the source currently , which can be done with the free Express version of Visual Studio. The next release will have separate setups for each version.

Can you run unit tests on a package via ssis?

There is the option of generating unit tests automatically for existing packages via the ssisUnit API. While this can improve code coverage, I would caution you not to rely on it to verify real functionality.

Can you use an expression in ssisunit?

Yes, the Asserts in ssisUnit can use expressions. These are C#-based expressions that evaluate to True or False. You can use an expression like “ ( (DateTime)result).Date==DateTime.Now.Date” to check that the result of the Assert command is equal to today’s date. “result”, in the expression, represents the object returned by the command associated with the Assert. You can apply pretty much any C# / .NET operation to the result object. For more examples, check out this page.

What is Haroon’s career?

Haroon’s deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional. He began his professional life as a computer programmer more than 10 years ago working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data. His work and interest revolves around Database-Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration along with Database Life Cycle Management (DLM).

What does SSIS stand for?

SSIS stands for SQL Server Integration Services and generally refers to SSIS Packages.

Why is multicasting important?

Multicasting data is necessary when you have to copy exactly the same data to two different destinations. It is quite a common practice in business intelligence or database solutions. We can multicast data with the help of the transformation available in the SSIS Package – the Multicast Transformation.

How to rename a data flow task in SSIS?

In SSIS Toolbox, drag Data Flow Task and drop it on to the surface of the Connection Flow designer. There, we rename the Data Flow Task to DFT Multicasting Data – click on the name and enter the new one:

How to join a source component with a multicast transformation?

Join the source component with the Multicast transformation by joining the success arrow also known as the success constraint of the source component. Remember to save your work!

Why is it important to have a similar sort of table matching with the source database?

It is necessary for a successful data transfer.

Can we multicast data?

We can multicast data with the help of the transformation available in the SSIS Package – the Multicast Transformation.