How do I perform automated unit testing in SSIS packages?

sql-server unit-testing ssis
Ray picture Ray · Oct 22, 2008 · Viewed 11k times · Source

How can I unit test SSIS packages? I want to be able to create and maintain unit tests for various components such as the workflow tasks, data flow tasks, event handlers, etc.

Are there any existing techniques, frameworks, and/or tools that can be used?

Answer

Ray picture Ray · Oct 22, 2008

ssisUnit

A unit testing framework for SQL Server Integration Services

Related questions

How do I unit test and integration test my SSIS packages?

This question mentions two libraries, both of which aren't maintained and one has broken links to the source and documentation. SSISUnit was last updated in 2008 and SSIStester has broken links in the documentation and hasn't been updated since 2013. The answers …

Read More
How can I know when SQL Full Text Index Population is finished?

We are writing unit tests for our ASP.NET application that run against a test SQL Server database. That is, the ClassInitialize method creates a new database with test data, and the ClassCleanup deletes the database. We do this by …

Read More
How to simulate a deadlock in SQL Server in a single process?

Our client side code detects deadlocks, waits for an interval, then retries the request up to 5 times. The retry logic detects the deadlocks based on the error number 1205. My goal is to test both the deadlock retry logic and deadlock …

Read More