I've been working on some data transformation tasks in SSIS. Visual Studio has gotten better in 2008 in it's usability, but I find there are some things that annoy me (i.e. When I delete something in the Package Explorer it refreshs the whole screen bringing me back to the top of the tree. Also, lack of some keyboard shortcuts.) Is there any other DTSx package editors out there or plug-ins for VS, and are they worth the trouble?
我一直在研究SSIS中的一些数据转换任务。 Visual Studio在2008年的可用性方面变得越来越好,但我发现有些东西让我烦恼(即当我在Package Explorer中删除某些东西时,它会刷新整个屏幕,让我回到树的顶端。而且,缺少一些键盘快捷键。)是否有其他DTSx包编辑器或VS的插件,他们值得吗?
3 个解决方案
#1
For things like this, believe it or not, the XML is pretty readable if you open the file as XML in visual studio and do a Ctrl+K, Ctrl+D to reformat the XML document.
对于这样的事情,不管你信不信,如果你在visual studio中以XML格式打开文件并按Ctrl + K,Ctrl + D重新格式化XML文档,那么XML就非常易读。
#2
Have you tried looking at Rhino.ETL? It's a in-code replacement for SSIS, although I haven't used it personally.
你试过看Rhino.ETL吗?虽然我没有亲自使用它,但它是SSIS的代码内替代品。
Object Oriented ETL using RhinoETL
使用RhinoETL的面向对象的ETL
Rhino ETL 2.0
#3
CodePlex project BIDS Helper helps a lot when editing SSIS package. It is plug-in for BIDS. I use it in my work and find it quite useful.
CodePlex项目BIDS Helper在编辑SSIS包时有很多帮助。它是BIDS的插件。我在工作中使用它并发现它非常有用。
#1
For things like this, believe it or not, the XML is pretty readable if you open the file as XML in visual studio and do a Ctrl+K, Ctrl+D to reformat the XML document.
对于这样的事情,不管你信不信,如果你在visual studio中以XML格式打开文件并按Ctrl + K,Ctrl + D重新格式化XML文档,那么XML就非常易读。
#2
Have you tried looking at Rhino.ETL? It's a in-code replacement for SSIS, although I haven't used it personally.
你试过看Rhino.ETL吗?虽然我没有亲自使用它,但它是SSIS的代码内替代品。
Object Oriented ETL using RhinoETL
使用RhinoETL的面向对象的ETL
Rhino ETL 2.0
#3
CodePlex project BIDS Helper helps a lot when editing SSIS package. It is plug-in for BIDS. I use it in my work and find it quite useful.
CodePlex项目BIDS Helper在编辑SSIS包时有很多帮助。它是BIDS的插件。我在工作中使用它并发现它非常有用。