与存储过程相比，使用 SSIS 包的优势是什么? [英] Advantages of using SSIS packages over stored procedures?

问题描述

如果我可以使用存储过程来满足所需的 ETL 要求，那么使用 SSIS 包有什么好处?我的 ETL 内容没什么大不了的.

If I can do the required ETL requirements using stored procedures, any advantages of using SSIS packages instead? My ETL stuff is nothing major.

我想使用旧技术.我喜欢 SQL.旧技术并不等于过时，因为存储过程不会很快消失.

I feel like using an old technology. I like SQL. Old technology does not equal obsolete as stored procedures won't go away any time soon.

推荐答案

如果您的 ETL 主要是 E 和 L，而 T 很少，并且如果您可以编写 SP 使它们不依赖游标，那么仅限 SP 的路线可能没问题.

If your ETL is mostly E and L, with very little T, and if you can write your SPs so they don't rely on cursors, then going the SP-only route is probably fine.

对于更复杂的过程，尤其是那些涉及大量变换、缓慢变化的维度、数据挖掘查找等的过程，SSIS 具有三个优势.

For more complex processes, particularly those that involve heavy transforms, slowly changing dimensions, data mining lookups, etc, SSIS has three advantages.

首先，它非常有效地管理内存，与单独的 T-SQL 相比，这可以带来巨大的性能提升.

First, it manages memory very efficiently, which can result in big performance improvements compared to T-SQL alone.

其次，图形界面让您可以比手工制作的 T-SQL 更轻松地构建大型、复杂和可靠的转换.

Second, the graphical interface lets you build large, complex and reliable transforms much more easily than hand-crafted T-SQL.

第三，SSIS 可让您更轻松地与其他外部资源进行交互，这对于数据清理等工作非常方便.

And third, SSIS lets you more easily interact with additional external sources, which can be very handy for things like data cleansing.

这篇关于与存储过程相比，使用 SSIS 包的优势是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！