Planning for Katmai (the next version of SQL Server) is well underway. Integration Services is still a version 1 product and as with all v1 products there are alot of improvements that can be made. I've listed a few suggestions here and here.
In an attempt to try and get some of my hopes for Katmai actually into the product I've made alot of submissions at the Product Feedback Center. Here's a list of some UI and debugging enhancements that I'd like to see make it in there:
- Include name of data flow in data viewer
- Execute without debugging on context menu
- Display the number of Forloop iterations
- Drag component into a data path
- Auto layout with Zoom to fit
- Watch anything in the object model from a Watch window
- TOKENISE() function
- Can't change all of the properties of the HTTP Connection Manager using expressions
- Copy/paste variables between packages
- View the contents of a raw file in the raw file source adapter
- Execute from here in control-flow
- Use expressions in annotations
- Use a newly derived column as the source of another column in the same Derived Column component
- Create objects from a configuration file
- Append in recordset destination
- View column metadata in derived column component
- Store Object variables in checkpoint files
- View the SQL statement stored in a variable from the OLE DB Source Editor
And here's an important one from Brian Knight that I'm tracking also:
- PackageID and SourceIDs need to regenerate automatically when creating new packages
If you agree that they would be useful then feel free to click through and your weight by voting appropriately and adding comments. I'd appreciate it - and if you do then they're more likely to make it in. And remember that you can add these to your own tracking list as well.
And reply here as well - let me know what you think of some of these suggestions. I'd really like to hear some feedback.
-Jamie