SSIS Unit Tests

Salam 26 Reputation points
2022-09-21T12:06:40.697+00:00

Hi, is there any ready-to-use framework or tool to allow doing unit testing for SSIS projects? I went through some sites where they talk about SSISTester (even a doc from MS dated 2013) but it seems that this tool is not maintained and is broken.
I am using SQL SSIS 2016 and 2019

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,703 questions
Developer technologies | Visual Studio | Testing
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Tianyu Sun-MSFT 34,441 Reputation points Microsoft External Staff
    2022-09-22T06:13:33.907+00:00

    Hi @Salam ,

    Welcome to Microsoft Q&A forum.

    I believe there are some ready-to-use framework or tools to allow doing unit testing for SSIS projects. But, as you mentioned, the document which talks about SSISTester is no longer updated. You may need to consider looking for and using some other open source or third-party framework/tools. Please check if this thread: SSIS Unit Testing code coverage helps.

    Best Regards,
    Tianyu

    • If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
      Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.