如何对SSIS包进行单元测试和集成测试?

时间:2021-06-18 07:32:43

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?

还有其他选择吗?

1 个解决方案

#1


7  

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

执行SSIS单元测试的最基本方法是创建您自己的测试包。在下面的例子:

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

执行SSIS单元测试的最流行的工具是您列出的工具:

  • SSISUnit
  • SSISUnit
  • SSISTester
  • SSISTester

But after making a deep search i found a new way that is BizUnit. BizUnit Framework which is predominantly used for the Biz Unit testing can be customized to test SSIS Package as well. More info in the link below

但在深入调查之后,我发现了一种新的方法——BizUnit。主要用于Biz单元测试的BizUnit框架也可以定制为SSIS包测试。更多信息请见下面的链接

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

另外,如果您的意思是通过测试包验证(元数据、连接等),您可以按照我在SO问题中的回答

#1


7  

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

执行SSIS单元测试的最基本方法是创建您自己的测试包。在下面的例子:

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

执行SSIS单元测试的最流行的工具是您列出的工具:

  • SSISUnit
  • SSISUnit
  • SSISTester
  • SSISTester

But after making a deep search i found a new way that is BizUnit. BizUnit Framework which is predominantly used for the Biz Unit testing can be customized to test SSIS Package as well. More info in the link below

但在深入调查之后,我发现了一种新的方法——BizUnit。主要用于Biz单元测试的BizUnit框架也可以定制为SSIS包测试。更多信息请见下面的链接

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

另外,如果您的意思是通过测试包验证(元数据、连接等),您可以按照我在SO问题中的回答