.Net vs SSIS:SSIS 应该用于什么? [英] .Net vs SSIS: What should SSIS be used for?

问题描述

如果我可以选择使用 .Net 并且可以在 .Net 中很好地进行数据transformations，那么我什么时候需要 SSIS?SSIS 是否有更好的任务?透明度带来的额外好处值得吗?这只是我更舒服的吗?确定这一点的最佳做法是什么?

If I have the option of using .Net and can do data transformations just fine in .Net, when would I need SSIS? Is there a certain task that SSIS would be better for? Are the added benefits of transparency worth it? Is it just what I am more comfortable with? What are the best practices for determining this?

推荐答案

好问题.

如果数据传输量巨大?您是否正在处理多个数据文件并需要事务(在文件系统级别和数据库级别)?您是否在处理不同位置的多个数据源(例如 ftp、本地文件系统、数据库)?

if the amount of data transfer huge? are you processing multiple data files and need transactions (both at file system level and database level)? are you dealing with multiple data sources at different locations (for eg ftp, local file system, database)?

如果上面的答案是肯定的，那么继续使用 ssis.基本上 .net 对小数据导入/导出工作很酷，但是当您有更复杂的事情时，ssis 绝对是赢家

if answers to above are yes then go ahead with ssis. basically .net is cool with small data import / export jobs, but when you have anything more complex, ssis is a definite winner

我关注的另一件事是 - 当 ssis 中的所有内容都可用时，是否值得编写 .net 代码.(不要误会我 - 我喜欢编码)但是，任何你编码的东西，你都需要维护:-)

the other thing which i look at is - is it worth writing .net code when everything is available inside ssis. (dont mistake me - i love coding) however, anything you code, you need to maintain :-)

这篇关于.Net vs SSIS:SSIS 应该用于什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！