sql-server - 如何对SSIS包进行单元测试和集成测试？(How do I unit test and integration test my SSIS packages?)

Question

posted Mar 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

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.

(SSISUnit的最新更新时间为2008年， SSIStester的文档中的链接已损坏，自2013年以来未更新。)

The answers on social.msdn.microsoft.com also generally point to one of those two libraries, or some sort of custom solution.

(social.msdn.microsoft.com上的答案通常也指向这两个库之一，或某种自定义解决方案。)

Are there any other options?

(还有其他选择吗？)

2018-10-09 Bounty Update (2018-10-09赏金更新)

Is there any updates that are related to newer versions of SSIS (2015+)?

(是否有与更新版本的SSIS（2015+）相关的??更新？)

I have already checked similar questions:

(我已经检查过类似的问题：)

ask by mattrowsboats translate from so

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

深蓝 · Answer 1 · 2021-03-06T04:21:28+0000

The most Basic way to perform a SSIS Unit Testing is to create your own testing package.

(执行SSIS单元测试的最基本方法是创建自己的测试包。)

Example below:

(下面的例子：)

The Most popular Tools to perform SSIS Unit Testing are the ones you listed:

(您列出的是执行SSIS单元测试的最受欢迎的工具：)

But after making a deep search i found a new way that is BizUnit .

(但是在进行深入搜索之后，我发现了一种新方法，即BizUnit 。)

BizUnit Framework which is predominantly used for the Biz Unit testing can be customized to test SSIS Package as well.

(可以定制主要用于Biz Unit测试的BizUnit Framework ，以测试SSIS包。)

More info in the link below

(以下链接中的更多信息)

Also if you mean by testing Package Validation (metadata , connections , ...etc), you can follow my answer in this SO question

(另外，如果您是通过测试软件包验证（元数据，连接等）来表示，那么您可以按照我在这个问题中的回答)