SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Hi, can you please let me know which one of those tools you used SentryOne, SSISUnit or BizUnit?
SSIS Unit Testing code coverage
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 94%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Supravat Samanta
21
Reputation points
Question related to SSIS Unit Testing code coverage.
We are trying to use external tools like SentryOne, SSISUnit, BizUnit etc for generating automated Unit Test case for our existing SSIS solution projects. Its working fine for generating automatic Unit test cases.
But its not supporting the code coverage(Test/Analyze Test Coverage).
Is it possible to generate the code coverage for SSIS components. And also any specific tool we can use for SSIS Unit Testing which will be supporting code coverage. Any help you could provide would be much appreciated.
SQL Server Integration Services
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 35%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Salam 26 Reputation points2022-09-22T07:05:53.96+00:00 -
Supravat Samanta 21 Reputation points
2022-12-18T21:35:00.013+00:00 Looking for these tools but we are not sure whether these tools will support Unit Testing code coverage in Sonar.
Sign in to comment -
-
ZoeHui-MSFT 41,551 Reputation points2021-09-01T07:54:56.98+00:00 Hi @Supravat Samanta ,
Not familiar with this topic, I did some research and have not found a way to generate the code coverage for SSIS components.
There is few related topic about your issue.
You may keep this case open to see if any other experts will give you some professional advice.
Regards，
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
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.
Hot issues October