views:

217

answers:

3

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?

+1  A: 

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.

Dave Markle
+1  A: 

Have you tried looking at Rhino.ETL? It's a in-code replacement for SSIS, although I haven't used it personally.

Object Oriented ETL using RhinoETL

Rhino ETL 2.0

James Gregory
+1  A: 

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.

Ken Yao