SSIS和Pentaho
有没有人同时使用这两种方法进行比较.我正在做一个学校项目，因此SSIS的成本不是问题，因为我们已经拥有它的许可证.
Has anyone used both of these to provide a good comparison. I am doing a school project so the cost of SSIS isn't an issue as we already have the license for it.
正在发生的事情的背景.我将把大约10年的专利信息下载到平面文件中.结果将是2,080个定界文件.我想要一种将它们一次全部加载到MS SQL Server中的方法.然后，我希望能够在发布其他文件时将其附加到数据库中.
Background on whats going on. I will be downloading about 10 years of patent information into flat files. The result will be 2,080 delimited files. I want a way to load them into MS SQL server all at once. Then I want to be able to append additional files into the DB as they are released.
该软件的速度并没有让我感到困扰，因为我只能让它运行一整夜.我只是在寻找具有某种灵活性，更重要的是相当易于使用的东西.我以前从未做过像这样的项目，并且会向董事会学习如何做.
Speed of the software doesn't bother me much as I can just let it run overnight. I am just looking for something with some flexibility, and more importantly fairly easy to use. I have never done a project like this before and will be learning how to do this from the boards.
谢谢！
在实际的实时项目中都使用了这两种方法.与SSIS相比，我确实更喜欢Pentaho(PDI)，因为它易于使用且具有灵活性. 在开始使用该主题之前，请先阅读一些有关该主题的内容.有两本关于水壶(PDI)的优秀书籍，或者您可以阅读PDI的帮助"菜单中的入门".如果您被困在IRC上或## pentaho，则该论坛是一个好地方. 您可以在欢迎"屏幕中找到样本，这也很有帮助. 希望您喜欢它，我知道我仍然会做.自2006年以来一直在使用它，当我不得不在某些项目上使用SSIS时总是很生气:-)
Have used both in real live projects. I do prefer Pentaho (PDI) over SSIS because of its ease of use and flexibility. Do read a little on the subject before you start using it. There are a couple of excellent books on kettle (PDI), or you could just read the Get Started in the Help menu of PDI. The forum is a good place if you are stuck or ##pentaho on IRC. What also helps a lot are the Samples that you can find in the Welcome Screen. I hope you enjoy it, I know I still do. Have been using it since 2006 and am always pissed when I have to use SSIS on some project :-)
PS:使用jtds jdbc驱动程序连接到SQL Server数据库，它将为您省去一些麻烦
PS : use a jtds jdbc-driver to connect to a SQL Server db, it will save you some headaches
希望这会有所帮助，
巴特