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

问题描述

如果我可以选择使用 .Net ，并且可以在.Net中进行数据转换，那么我需要 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)?

如果以上答案是肯定的，那么继续进行sis。基本上.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与SSIS：SSIS应该用于什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！