Share via

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,525 questions
Visual Studio Testing
Visual Studio Testing
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Testing: The act or process of applying tests as a means of analysis or diagnosis.
338 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tianyu Sun-MSFT 29,446 Reputation points Microsoft Vendor
    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.