SSIS 组件与 C# 脚本性能 [英] SSIS component vs C# script performance

问题描述

我正在使用 SSIS 开发 ETL 包.我有一些半复杂的数据转换、验证和字段定义.我可以通过使用一些组件来实现它，例如 Derive Column 、Conditional、数据转换等.我的第二个选择是编写 C# 脚本并使用语言 (C#) 功能实现所有复杂性.
哪种方法在大数据上更有效(使用组件或 C# 脚本)?
谢谢

I am developing an ETL package using SSIS. I have some semi complex Data Conversion, validation and field definitions. I can implement it by using some components such as Derive Column , Conditional, data conversion and others. My second option is to write C# script and implement all complexities using language (C#) capabilities.
Which method is more efficient on big data (Using components or C# script)?
Thanks

推荐答案

开箱即用的组件通常可能比脚本组件中的自定义代码更快，除非您需要一大堆组件来完成一些可以用简单的 C# 代码行完成.

The out of the box components are in general probably faster then custom code in a Script Component, unless you need a whole bunch of components to accomplish something that can be done in a simple C# line of code.

另一件事是使用(部分)阻塞组件(如排序、联合、聚合等).如果你需要这些，但你也可以在一个非阻塞的脚本组件中完成，那么使用脚本组件会更快......

An other thing is the use of (partial) blocking components (like sort, union, aggregate, etc.). If you need those, but you could also do it in a none blocking Script Component then it could faster to use the Script Component...

您应该在包的性能和可读性之间找到平衡.添加 C# 可能会使非程序员难以维护，但如果几行记录良好的 C# 行可以采用一大堆开箱即用的组件......

You should find a balance between performance and readability of your package. Adding C# could make it hard to maintain for non-programmers, but if a couple of well documented C# lines could take a way a whole bunch of out of the box components....

这篇关于SSIS 组件与 C# 脚本性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！